Re: High Disk Utilization Due to Query on Large Table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux