Re: Changing default fillfactor for the whole database

2025-04-27 Thread Christophe Pettus
> On Apr 27, 2025, at 06:54, Ron Johnson wrote: > > I agree with him, though, that this a foot-gun: most table's aren't that > UPDATE heavy. There is plenty of precedent for GUCs that seem to be useful, but really should never be touched except in the case of fairly uncommon workloads. Ho

Re: Changing default fillfactor for the whole database

2025-04-27 Thread Ron Johnson
On Sat, Apr 26, 2025 at 10:31 PM Marcelo Fernandes wrote: > Hi there, > > I have a scenario where virtually all user tables in the database will > need to > have a lower fill factor. > > It would have been handy to have a way to set this default, but as of now, > I > don't think the default can b

Re: Changing default fillfactor for the whole database

2025-04-26 Thread David Rowley
On Sun, 27 Apr 2025 at 14:31, Marcelo Fernandes wrote: > I have a scenario where virtually all user tables in the database will need to > have a lower fill factor. > Does this make sense? Have I missed something about being able to change this > on a database level? I suspect that it's possible

Re: Changing default fillfactor for the whole database

2025-04-26 Thread Christophe Pettus
> On Apr 26, 2025, at 19:31, Marcelo Fernandes 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,