Re: Synthetic keys and index fillfactor - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Synthetic keys and index fillfactor
Date
Msg-id CAKFQuwanbq3T1xiysk=kP9Oy5qtNyXdFG8asPxttBq_fJg==8w@mail.gmail.com
Whole thread Raw
In response to Synthetic keys and index fillfactor  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Synthetic keys and index fillfactor  (Gavan Schneider <list.pg.gavan@pendari.org>)
Re: Synthetic keys and index fillfactor  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
On Thu, Jan 12, 2023 at 3:45 PM Ron <ronljohnsonjr@gmail.com> wrote:

(This mostly pertains to recreating a PK on an existing table.)

Is there any reason to have the PK index on an ever-increasing field (for
example SERIAL, sequence or timestamp fed by clock_timestamp() at time zone
'UTC') be anything but fillfactor=100?

New records will always be added to the "lower right hand corner" of the
tree, so having 20% empty space in the rest of the tree would just waste
space (mainly buffers, but disk space could even start to add up on Very Big
Tables).


Yes, at least that is what I gather from the advice on the CREATE INDEX page.


David J.

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Synthetic keys and index fillfactor
Next
From: Gavan Schneider
Date:
Subject: Re: Synthetic keys and index fillfactor