Re: When to REINDEX a serial key?

On 06.07.21 14:19, Ron wrote:
> On 7/6/21 4:52 AM, David Rowley wrote:
>> On Tue, 6 Jul 2021 at 21:35, Ron <ronljohnsonjr(at)gmail(dot)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 tell whether 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?

There is no such thing as a lopsided B-tree, because a B-tree is by
definition self-balancing. Perhaps that answers your original question.

Bloat is generally something people are concerned about when they think
about reindexing their indexes. But append-only workloads, such as what
you describe, normally don't generate bloat.