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

From Tom Lane
Subject Re: [PATCHES] default resource limits
Date
Msg-id 9484.1135609867@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] default resource limits  ("Andrew Dunstan" <andrew@dunslane.net>)
List pgsql-hackers
"Andrew Dunstan" <andrew@dunslane.net> writes:
> Tom Lane said:
>> The existing initdb code actually does try to scale them in sync to
>> some extent ---

> Yes, I know. What I meant was that we could try using one phase
> rather than two. But that's only one possible approach.

I think that's a bad idea, mainly because max_connections is constrained
by more things than just SHMMAX.  In a scenario where the number of
semaphores constrains max_connections, you'd probably end up failing to
push shared_buffers up as high as it could be.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fixing row comparison semantics
Next
From: Bruce Momjian
Date:
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and