On 10/10/07, Josh Trutwin <josh@xxxxxxxxxxxxxxxxxxx> wrote: > On Wed, 10 Oct 2007 10:20:02 -0500 > "Scott Marlowe" <scott.marlowe@xxxxxxxxx> wrote: > > > In 7.4, using 25% is often too high a setting for it to handle well, > > and the practical useful maximum is usually under 10,000 > > shared_buffers, and often closer to 1,000 to 5,000 > > Scott - interesting reply. Is this also true for 8.1? I currently > have mine set to 16384 - server has 3.5 GB of total memory. No, starting with 8.0, the code to manage the shared_buffers is much more efficient with large numbers of shared buffers. With 8.0 and up the primary considerations are that the shared_buffers be big enough to hold your working set, but not so big as to run the system out of memory for other things, sorts, kernel caching, etc... ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
