From: | khan Affan <bawag773(at)gmail(dot)com> |
---|---|
To: | "Wong, Kam Fook (TR Technology)" <kamfook(dot)wong(at)thomsonreuters(dot)com> |
Cc: | "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-25 12:58:52 |
Message-ID: | CAF4emOmq9p2zUvef7sTE2StmaGgOCnCp2wCDaYDWx=+c8Kgdwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Wasim Devale | 2024-07-25 13:30:31 | Queries are failing on standby server |
Previous Message | Wong, Kam Fook (TR Technology) | 2024-07-24 21:06:45 | How to detect if a postgresql gin index is bloated |