> 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.
