Re: initdb profiles - Mailing list pgsql-hackers

From Tom Lane
Subject Re: initdb profiles
Date
Msg-id 2108.1126143433@sss.pgh.pa.us
Whole thread Raw
In response to initdb profiles  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: initdb profiles
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> I accept the "run from init.d" argument. So then, is there a case for 
> increasing the limits that initdb works with, to reflect the steep rise 
> we have seen in typically available memory at the low end?

I can't see any particular harm in having initdb try somewhat-larger
values ... but how far does that really go towards fixing the issues?

Personally, the default value I currently see as far too tight is
max_fsm_pages.  I'd rather see initdb trying to push that up if it's
able to establish shared_buffers and max_connections at their current
maxima.

> ... it would be nice to try to allow 
> one connection per standard allowed apache client (default is 256 
> non-threaded and 400 threaded, I think).

That's a mostly independent consideration, but it seems fair enough.
Can we check the exact values rather than relying on "I think"?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: initdb profiles
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_config/share_dir