Re: Hardware Performance Tuning

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 majordomo@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073