Postgres Pro
Downloads
Home   >   mailing lists

Re: How to detect if a postgresql gin index is bloated - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: How to detect if a postgresql gin index is bloated
Date
Msg-id 5e5adf91196fadea03bc20575f6fc88cf003df5a.camel@cybertec.at
Whole thread Raw
In response to Re: How to detect if a postgresql gin index is bloated  (Keith Fiske <keith.fiske@crunchydata.com>)
Responses Re: How to detect if a postgresql gin index is bloated
List pgsql-admin
Tree view 
On Thu, 2024-07-25 at 23:01 -0400, Keith Fiske wrote:
> Any more insight on how to use those two options to actually calculate GIN bloat?
> From what I could tell pgstattuple didn't provide anything that could be used.
> I hadn't looked further into the other yet, but if you know how to do that already
> that info would be great.

I don't think that there is anything smarter than to create a new index with the
same definition and see if it is much smaller than the original index...

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Rajesh Kumar
Date:
Subject: DR setup in RHOS
Next
From: Laurenz Albe
Date:
Subject: Re: Queries are failing on standby server