From: | Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com> |
---|---|
To: | 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 03:01:28 |
Message-ID: | CAODZiv5UuqoisPSKsDeKve7F0Ge_j40O_+OzRTQZ8PHu2L4D-Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, Jul 25, 2024 at 8:59 AM khan Affan <bawag773(at)gmail(dot)com> wrote:
> Hello Kam Fook
> You can use pgstattuple extension, & you can use pg_trgm or
> gin_index_stats functions from the pgstattuple extension to check for bloat
> in GIN indexes.
> Thank & Regards
>
> *Muhammad Affan (*아판*)*
>
> *PostgreSQL Technical Support Engineer** / Pakistan R&D*
>
> On Thu, Jul 25, 2024 at 2:07 AM Wong, Kam Fook (TR Technology) <
> kamfook(dot)wong(at)thomsonreuters(dot)com> wrote:
>
>> I have a GIN index. Is there a way to detect if a postgres GIN index is
>> bloated or not? The regular select * from pgstatindex(‘indexname’); does
>> not work because the GIN index is not btree index.
>>
>>
>>
>> Thank you
>> This e-mail is for the sole use of the intended recipient and contains
>> information that may be privileged and/or confidential. If you are not an
>> intended recipient, please notify the sender by return e-mail and delete
>> this e-mail and any attachments. Certain required legal entity disclosures
>> can be accessed on our website:
>> https://www.thomsonreuters.com/en/resources/disclosures.html
>>
>
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.
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar | 2024-07-26 04:53:04 | DR setup in RHOS |
Previous Message | Keith Fiske | 2024-07-26 02:59:06 | Re: Queries are failing on standby server |