Re: Changing default fillfactor for the whole database

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Changing default fillfactor for the whole database
Дата
Msg-id 55A52200-4335-4351-BDA4-604A860B24E9@thebuild.com
обсуждение исходный текст
Ответ на Changing default fillfactor for the whole database  (Marcelo Fernandes <marcefern7@gmail.com>)
Список pgsql-general

> On Apr 26, 2025, at 19:31, Marcelo Fernandes <marcefern7@gmail.com> wrote:
> Does this make sense? Have I missed something about being able to change this
> on a database level?

You haven't missed anything; there's no setting that controls the default for fillfactor.

Everyone's use-case is different, of course, but my feeling is that a correct fillfactor is very sensitive to the
insert/updatepattern for a particular table, so I'm not sure it makes sense to have a system-wide default.  I can
certainlysee it being a foot-gun, in setting it to (say) 50 and then some months later creating a table that is going
toget very large, but is not update-heavy. 


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