Postgres Pro
Downloads
Home   >   mailing lists

Re: Re-index - Mailing list pgsql-admin

From Keith
Subject Re: Re-index
Date
Msg-id CAHw75vsjnQ10aN=jbTTYECJMtC-vs2XLhx8AoJORpQn_GyS7=g@mail.gmail.com
Whole thread Raw
In response to Re: Re-index  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Tree view


On Tue, Nov 24, 2020 at 9:15 AM Bruce Momjian <bruce@momjian.us> wrote:
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




The wiki that Bruce linked is a great resource. I've also written a tool to better help monitor for table & index bloat


Keith

pgsql-admin by date:

Previous
From: MichaelDBA
Date:
Subject: Re: Streaming Replication replay lag
Next
From: "David G. Johnston"
Date:
Subject: Re: ERROR : invalid transaction termination : PostgreSQL v12