| From: | Marcelo Fernandes <marcefern7(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Changing default fillfactor for the whole database |
| Date: | 2025-04-27 02:31:19 |
| Message-ID: | CAM2F1VMu747bv5X3wTvhzLQUWRaJzREdaS=coVz+WjxkBjzvng@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe Pettus | 2025-04-27 03:15:42 | Re: Changing default fillfactor for the whole database |
| Previous Message | Igor Korot | 2025-04-27 01:41:14 | Re: How to get the data from the query |