Обсуждение: Re-index
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?
regards
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
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