On Thursday 08 September 2005 13:16, Andrew Dunstan wrote:
> Initdb already
> has adaptive rules - look at the source - and Tom suggests adding
> another set for max_fsm_pages. All I'm doing is to suggest that we need
> to tweak those.
>
I'm curious how this could work... istm its fairly hard to predict a
reasonable value for max_fsm_pages before you ever create a single database
in your cluster... I could perhaps see this as becoming self tuning with an
integrated autovacuum, where autovacuum stores the values needed for this and
max_fsm_relations so that upon any restart these values get automatically
updated to a reasonable number. Even more ideal would be to not have them
require restart at all, but thats yet another level of magic...
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
