Changing default fillfactor for the whole database - Mailing list pgsql-general

From Marcelo Fernandes
Subject Changing default fillfactor for the whole database
Date
Msg-id CAM2F1VMu747bv5X3wTvhzLQUWRaJzREdaS=coVz+WjxkBjzvng@mail.gmail.com
Whole thread Raw
Responses Re: Changing default fillfactor for the whole database
Re: Changing default fillfactor for the whole database
Re: Changing default fillfactor for the whole database
List pgsql-general
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 be changed.

I have looked at `share/postgresql.conf.sample` file, and couldn't see
anything indicating this value could be changed.

Though I'm aware there's an ALTER TABLE command that can be used for that, I
think it would be good to avoid some future errors (forgetting to set it) if I
could change the default value.

Does this make sense? Have I missed something about being able to change this
on a database level?

Thanks,
Marcelo.



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: How to get the data from the query
Next
From: Christophe Pettus
Date:
Subject: Re: Changing default fillfactor for the whole database