Home > mailing lists

Re-index - Mailing list pgsql-admin

From	Yambu
Subject	Re-index
Date	November 24, 2020 13:53:42
Msg-id	CALhHtcA+76ivSOZsxNHOrvLbYY3L_jPDvhFY-K6RzKxFGhXp7A@mail.gmail.com Whole thread Raw
Responses	Re: Re-index
List	pgsql-admin

How do I check if an index is bloated?

Also if i delete a number of records eg 60% of the records in a table , do i need to reindex?

regards

From: Sachin Kumar
Date: 24 November 2020, 13:37:32
Subject: Re: PG Admin 4.28 is crashing while viewing 10M row data

From: Bruce Momjian
Date: 24 November 2020, 17:15:13
Subject: Re: Re-index