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

From Ron
Subject Re: When to REINDEX a serial key?
Date
Msg-id 4cc31261-a074-f756-9739-c53400dd298b@gmail.com
Whole thread Raw
In response to Re: When to REINDEX a serial key?  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: When to REINDEX a serial key?  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-general
On 7/6/21 4:52 AM, David Rowley wrote:
> 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

How does bloat relate to a lopsided b-tree?

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

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