FILLFACTOR and increasing index

Поиск
Список
Период
Сортировка
От Leonardo Francalanci
Тема FILLFACTOR and increasing index
Дата
Msg-id 760840.3913.qm@web29008.mail.ird.yahoo.com
обсуждение исходный текст
Список pgsql-general
Hi,


the doc pages are somehow "cryptic" regarding FILLFACTOR.
(well, at least they're cryptic to me, since I don't know a lot
of btree stuff...)

I have an index on a timestamp value that is inserted, for 90%
of the inserts, in increasing order. No updates, no deletes on the
table (appends only).

What would be the "right" or "sensible" FILLFACTOR in this case?

I guess the docs need some example of "sensible" values for
some of the "classic" cases? (I'm sure I'm not the only one
storing a timestamp index in time-order...)



Leonardo

В списке pgsql-general по дате отправления:

Предыдущее
От: Leonardo Francalanci
Дата:
Сообщение: Re: multiple group by on same table
Следующее
От: Iztok Stotl
Дата:
Сообщение: Re: Help with database recovery ...