Re: max_connections/shared_buffers (was Re: Beta4 Tag'd and Bundled ...) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: max_connections/shared_buffers (was Re: Beta4 Tag'd and Bundled ...)
Date
Msg-id 29409.1065461195@sss.pgh.pa.us
Whole thread Raw
In response to Re: max_connections/shared_buffers (was Re: Beta4 Tag'd  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> Anyone see a better way?

> Maybe just run one loop and try pairs of (shared_buffers, max_connections):
> (1000, 100) (800, 50) (600, 40) (400, 30) (200, 20) (50, 10)

Hmm ... that wouldn't work real well as-is, because if max_connections
is being constrained by a limit on SysV semaphores, we could find
ourselves restricting shared_buffers to no purpose.

Would it work to loop as above, and then try a second loop in which we
use the selected max_connections and see if we can make shared_buffers
bigger?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: max_connections/shared_buffers (was Re: Beta4 Tag'd
Next
From: Andrew Dunstan
Date:
Subject: db encoding