Re: Synthetic keys and index fillfactor

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Synthetic keys and index fillfactor
Дата
Msg-id CAKFQuwanbq3T1xiysk=kP9Oy5qtNyXdFG8asPxttBq_fJg==8w@mail.gmail.com
обсуждение исходный текст
Ответ на Synthetic keys and index fillfactor  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Synthetic keys and index fillfactor  (Gavan Schneider <list.pg.gavan@pendari.org>)
Re: Synthetic keys and index fillfactor  (Ron <ronljohnsonjr@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Synthetic keys and index fillfactor
Следующее
От: Gavan Schneider
Дата:
Сообщение: Re: Synthetic keys and index fillfactor