> On Apr 26, 2025, at 19:31, Marcelo Fernandes <marcefe...@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/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.
