Re: initdb profiles

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