On Tue, Nov 24, 2020 at 12:53:42PM +0200, Yambu wrote:
> Hi
>
> 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?
See:
https://wiki.postgresql.org/wiki/Index_Maintenance
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee