Re: default resource limits - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: default resource limits
Date
Msg-id 439DA18F.7080200@dunslane.net
Whole thread Raw
In response to Re: default resource limits  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:

>Andrew Dunstan <andrew@dunslane.net> writes:
>  
>
>>Nearly everyone seems to agree that the default for max_fsm_pages is 
>>woefully low, so I would like to have the default for this set 
>>unconditionally to 200,000 rather than 20,000. The cost would be just 
>>over 1Mb of shared memory, if the docs are correct. Alternatively, we 
>>could put this into the mix that is calculated by initdb, scaling it 
>>linearly with shared_buffers (but with the default still at 200,000).
>>    
>>
>
>  
>
>>I would also like to propose a more modest increase in max_connections 
>>and shared_buffers by a factor of 3.
>>    
>>
>
>I don't mind having initdb try larger values to see if they work, but
>if you are suggesting that we try to force adoption of larger settings
>I'll resist it.
>  
>

OK, works for me. The only thing I suggested might be set in stone was 
max_fsm_pages; I always envisioned the others being tested as now by initdb.

>"Factor of three" seems mighty weird.  The existing numbers (100 and 1000)
>at least have the defensibility of being round.
>
>    
>  
>

What numbers would you like? If what I suggested seems odd, how about 
targets of 400 connections, 4000 shared_buffers and 200,000 max_fsm_pages?

cheers

andrew




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Different length lines in COPY CSV
Next
From: Andreas Pflug
Date:
Subject: Re: pg_relation_size locking