High Disk Utilization Due to Query on Large Table

From: kasem adel <kasemadel8(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: High Disk Utilization Due to Query on Large Table
Date: 2025-01-21 18:10:13
Message-ID: CAP-pBm8NLe_zurg4Ub4cV-3p_S8-0H23NpQjcpXjjOr0apRCOw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Edwin UY 2025-01-21 23:28:01 Is there a way to check if objects are created with quotes or not?
Previous Message Rajesh Kumar 2025-01-21 14:56:42 Re: Commit with wait event on advisory lock!