Re: How to detect if a postgresql gin index is bloated

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com>, khan Affan <bawag773(at)gmail(dot)com>
Cc: "Wong, Kam Fook (TR Technology)" <kamfook(dot)wong(at)thomsonreuters(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to detect if a postgresql gin index is bloated
Date: 2024-07-26 04:57:53
Message-ID: 5e5adf91196fadea03bc20575f6fc88cf003df5a.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-07-26 05:08:11 Re: Queries are failing on standby server
Previous Message Rajesh Kumar 2024-07-26 04:53:04 DR setup in RHOS