public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ramakrishna m <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Performance Issue with Hash Partition Query Execution in PostgreSQL 16
Date: Wed, 6 Nov 2024 22:43:46 +0530
Message-ID: <CAG-eXHJ+KbQ8_k-jKSGZU9V6HkLKU2Jqz7nYMYGhHuC-Zqm7qQ@mail.gmail.com> (raw)
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.
Attachments:
[application/octet-stream] Postgres_hash_partion_issue.sql (10.0K, 3-Postgres_hash_partion_issue.sql)
download
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16
In-Reply-To: <CAG-eXHJ+KbQ8_k-jKSGZU9V6HkLKU2Jqz7nYMYGhHuC-Zqm7qQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox