Re: [PATCHES] default resource limits - Mailing list pgsql-hackers

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

Tom Lane wrote:

>BTW, I fat-fingered the calculations I was doing last night --- the
>actual shmem consumption in CVS tip seems to be more like 17K per
>max_connection increment, assuming max_locks_per_connection = 64.
>
>  
>


ITYM max_locks_per_transaction (which as the docs say is confusingly named).

So if we went to 256, say, as an upper limit on max_connections, that 
would account for an extra 2.6Mb of memory use - a pretty modest 
increase, really.


cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] default resource limits
Next
From: Andrew Dunstan
Date:
Subject: Re: [PATCHES] default resource limits