Re: Changing default fillfactor for the whole database

> On Apr 26, 2025, at 19:31, Marcelo Fernandes <marcefern7(at)gmail(dot)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/update pattern for a particular table, so I'm not sure it makes sense to have a system-wide default. I can certainly see it being a foot-gun, in setting it to (say) 50 and then some months later creating a table that is going to get very large, but is not update-heavy.