[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] Proof-of-concept for initdb-time shared_buffers selection
From:       Josh Berkus <josh () agliodbs ! com>
Date:       2003-07-31 16:43:32
[Download RAW message or body]

Manfred,

> Can't this be done on postmaster startup?  I think of two GUC
> variables where there is only one today: min_shared_buffers and
> max_shared_buffers.  If allocation for the max_ values fails, the
> numbers are decreased in a loop of, say, 10 steps until allocation
> succeeds, or even fails at the min_ values.

I think the archives are back up.  Take a look at this thread; we already had 
this discussion at some length, and decided that a max of 1000 was reasonable 
in advance of user tuning.  And, I believe, Tom has already written the code.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread]