Postgres Pro
Downloads
Home   >   mailing lists

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

From Rob Sargent
Subject Re: When to REINDEX a serial key?
Date
Msg-id 96E90DD3-5462-4D7A-9333-31AE17CE143D@gmail.com
Whole thread Raw
In response to Re: When to REINDEX a serial key?  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-general
Tree view 
>
> There is no such thing as a lopsided B-tree, because a B-tree is by definition self-balancing.  Perhaps that answers
youroriginal question. 
>
You do incur the cost of rebalancing often and the cost/frequency/extent  is related to fill factor.

>
>

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Question about how to handle numeric (decimal) data types while using libpq
Next
From: Lucas
Date:
Subject: Need suggestions about live migration from PG 9.2 to PG 13