Postgres Pro
Downloads
Home   >   mailing lists

Re: When to REINDEX a serial key? - Mailing list pgsql-general

From David Rowley
Subject Re: When to REINDEX a serial key?
Date
Msg-id CAApHDvq9e0-EuR9955CXbXCu8mNa8cuEyRRXLCJLfZKrtyHf6Q@mail.gmail.com
Whole thread Raw
In response to When to REINDEX a serial key?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: When to REINDEX a serial key?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view 
On Tue, 6 Jul 2021 at 21:35, Ron <ronljohnsonjr@gmail.com> wrote:
> The legacy RDBMS which I used to manage has a tool for analyzing (not in the Postgresql meaning of the word) an
index,and displaying a histogram of how many layers deep various parts of an index are.  Using that histogram, you can
tellwhether or not an index needs to be rebuilt. 
>
> How does one get the same effect in Postgresql?

There are a few suggestions in
https://wiki.postgresql.org/wiki/Show_database_bloat

David

pgsql-general by date:

Previous
From: Ron
Date:
Subject: When to REINDEX a serial key?
Next
From: Sudheer H R
Date:
Subject: Question about how to handle numeric (decimal) data types while using libpq