Re: Re-index

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