| From: | Ramakrishna m <ram(dot)pgdb(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Cc: | ravisql09(at)gmail(dot)com |
| Subject: | Performance Issue with Hash Partition Query Execution in PostgreSQL 16 |
| Date: | 2024-11-06 17:13:46 |
| Message-ID: | CAG-eXHJ+KbQ8_k-jKSGZU9V6HkLKU2Jqz7nYMYGhHuC-Zqm7qQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Team,
One of the queries, which retrieves a single record from a table with 16
hash partitions, is taking more than 10 seconds to execute. In contrast,
when we run the same query manually, it completes within milliseconds. This
issue is causing exhaustion of the application pools. Do we have any bugs
in postgrs16 hash partitions? Please find the attached log, table, and
execution plan.
size of the each partitions : 300GB
Index Size : 12GB
Postgres Version : 16.x
Shared Buffers : 75 GB
Effective_cache : 175 GB
Work _mem : 4MB
Max_connections : 3000
OS : Ubuntu 22.04
Ram : 384 GB
CPU : 64
Please let us know if you need any further information or if there are
additional details required.
Regards,
Ram.
| Attachment | Content-Type | Size |
|---|---|---|
| Postgres_hash_partion_issue.sql | application/octet-stream | 10.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2024-11-06 18:23:11 | Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 |
| Previous Message | Dominique Devienne | 2024-11-06 16:20:12 | About the stability of COPY BINARY data |