I need to update that. 7.4 will use many more shared buffers by default. Yes, they are very small because we want to start even on small machines.
--------------------------------------------------------------------------- Knut P. Lehre wrote: > The doc "PostgreSQL Hardware Performance Tuning" by Bruce Momjian, 16th > January 2003 says: "As a start for tuning, use 25% of RAM for cache size, > and 2-4% for sort size.", and "The default POSTGRESQL conguration allocates > 64 shared buffers. Each buffer is 8 kilobytes.". > Have I understood it correctly that "shared_buffers" should be set to 25% > of RAM divided by 8kB, and "sort_mem" to 2-4% of RAM? (If so, the default > values of 64 and 512 respectively, appear relatively small). > > Thanks, KP > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
