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

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: How to detect if a postgresql gin index is bloated
Дата
Msg-id 5e5adf91196fadea03bc20575f6fc88cf003df5a.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: How to detect if a postgresql gin index is bloated  (Keith Fiske <keith.fiske@crunchydata.com>)
Ответы Re: How to detect if a postgresql gin index is bloated
Список 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



В списке pgsql-admin по дате отправления: