Re: Re-index

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Re-index
Date: 2020-11-24 14:15:13
Message-ID: 20201124141513.GB29439@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee

In response to

  • Re-index at 2020-11-24 10:53:42 from Yambu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nikhil Shetty 2020-11-24 14:24:40 Streaming Replication replay lag
Previous Message Yambu 2020-11-24 10:53:42 Re-index