public inbox for [email protected]
help / color / mirror / Atom feedHigh Disk Utilization Due to Query on Large Table
2+ messages / 2 participants
[nested] [flat]
* High Disk Utilization Due to Query on Large Table
@ 2025-01-21 18:10 kasem adel <[email protected]>
2025-01-22 12:34 ` Re: High Disk Utilization Due to Query on Large Table Laurenz Albe <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: kasem adel @ 2025-01-21 18:10 UTC (permalink / raw)
To: pgsql-admin
Dears,
We are experiencing high disk utilization caused by a query running on a
table containing 300,000,000 rows. This issue has occurred after running
the ANALYZE process with default values.
We would greatly appreciate your urgent support to help resolve this issue.
Looking forward to your assistance.
Thanks
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: High Disk Utilization Due to Query on Large Table
2025-01-21 18:10 High Disk Utilization Due to Query on Large Table kasem adel <[email protected]>
@ 2025-01-22 12:34 ` Laurenz Albe <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2025-01-22 12:34 UTC (permalink / raw)
To: kasem adel <[email protected]>; pgsql-admin
On Tue, 2025-01-21 at 20:10 +0200, kasem adel wrote:
> We are experiencing high disk utilization caused by a query running on a table
> containing 300,000,000 rows. This issue has occurred after running the ANALYZE
> process with default values.
If you are waiting for someone to connect to your system and fix the problem,
you are going to wait in vain. If you want help, you have to provide information
that allows us to help you.
Please post the query and its EXPLAIN (ANALYZE, BUFFERS, SETTINGS) output.
Also tell us which PostgreSQL version you are using.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-01-22 12:34 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-01-21 18:10 High Disk Utilization Due to Query on Large Table kasem adel <[email protected]>
2025-01-22 12:34 ` Laurenz Albe <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox