[GENERAL] Hardware Performance Tuning

[Knut P. Lehre]

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]