| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | kasem adel <kasemadel8(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: High Disk Utilization Due to Query on Large Table |
| Date: | 2025-01-22 12:34:40 |
| Message-ID: | 0ee846d4003ff880a4faf77e52bb0ab73c1b230a.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | msalais | 2025-01-22 17:19:10 | RE: Commit with wait event on advisory lock! |
| Previous Message | shammat | 2025-01-22 07:46:07 | Re: Is there a way to check if objects are created with quotes or not? |