Re: initdb profiles - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: initdb profiles
Date
Msg-id 431F9EB3.7020102@dunslane.net
Whole thread Raw
In response to Re: initdb profiles  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:

>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.
>
>  
>

Ok. how would the logic go? Just have a function that runs max_fsm_pages 
checks after we call test_connections() and test_buffers(), or should 
there be some interplay between those settings? As I understand it, the 
current setting would consume all of 120,000 bytes of shared memory, so 
there could well be lots of head room.


>>... 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"?
>  
>

That's my reading of 
http://httpd.apache.org/docs/2.0/mod/mpm_common.html#maxclients




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: initdb profiles
Next
From: Tom Lane
Date:
Subject: Re: initdb profiles