From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Knut P(dot) Lehre" <k(dot)p(dot)d(dot)lehre(at)basalmed(dot)uio(dot)no> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Hardware Performance Tuning |
Date: | 2003-08-06 00:51:44 |
Message-ID: | 200308060051.h760pid02429@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Robert Norris | 2003-08-06 01:18:53 | pg_dump corrupts database? |
Previous Message | Dann Corbit | 2003-08-06 00:18:09 | Re: v7.4 Beta 1 Bundle Available for Testing ... |