Dead tuple ratio for table & index

From: kamal deen <kamaldeendba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Dead tuple ratio for table & index
Date: 2024-12-13 21:59:03
Message-ID: CAAGAcEe5Wq8XT5E_8DHS+-2pT2edSEpcGAx_ZpM6nRw3OtR33A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Wienhold 2024-12-14 00:13:01 Re: Postgis
Previous Message Pär Mattsson 2024-12-13 20:03:52 Postgis