Dead tuple ratio for table & index

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

To: pgsql-admin@xxxxxxxxxxxxxx
Subject: Dead tuple ratio for table & index
From: kamal deen <kamaldeendba@xxxxxxxxx>
Date: Sat, 14 Dec 2024 03:29:03 +0530

Hi All,

Kindly share the query details to identify the dead tuples ratio at table & index level.

We have noticed some of our partioned tables generating more WAL files during vacuumb.(around 50 to 60GB

(We are in the plan to remove this manual job later since auto vacuum is enabled)

Thanks in advance ☺️

Regards,

SK

Follow-Ups:
- Re: Dead tuple ratio for table & index
  - From: lakshmi sravya

Prev by Date: Postgis
Next by Date: Re: Postgis
Previous by thread: Benefit to increasing max_files_per_process?
Next by thread: Re: Dead tuple ratio for table & index
Index(es):
- Date
- Thread

[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