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

From Peter Eisentraut
Subject Re: max_connections/shared_buffers (was Re: Beta4 Tag'd
Date
Msg-id Pine.LNX.4.44.0310061919180.4051-100000@peter.localdomain
Whole thread Raw
In response to max_connections/shared_buffers (was Re: Beta4 Tag'd and Bundled ...)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: max_connections/shared_buffers (was Re: Beta4 Tag'd and Bundled ...)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane writes:

> Perhaps we should avoid all attempts at cuteness and just run the
> initial probes for workable shared_buffers with max_connections=20,
> as well as making that be the minimum max_connections value probed for.
>
> 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)

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_restore -d doesn't display output
Next
From: Tom Lane
Date:
Subject: Re: max_connections/shared_buffers (was Re: Beta4 Tag'd and Bundled ...)