Re: Re-index - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Re-index
Date
Msg-id 20201124141513.GB29439@momjian.us
Whole thread Raw
In response to Re-index  (Yambu <hyambu@gmail.com>)
Responses Re: Re-index  (Keith <keith@keithf4.com>)
List pgsql-admin
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




pgsql-admin by date:

Previous
From: Yambu
Date:
Subject: Re-index
Next
From: Nikhil Shetty
Date:
Subject: Streaming Replication replay lag