Re: Performance Tuning Document?

Bruce Momjian wrote:
>
<snip>
>
> I have added this to my performance paper:
>
> As a start for tuning, use 25% of ram for cache size, and 2-4% for sort
> size. Increase if no swapping, and decrease to prevent swapping. Of
> course, if the frequently accessed tables already fit in the cache,
> continuing to increase the cache size no longer dramatically improves
> performance.

That's pretty cool.

Reckon you should add in a good and clear example for people though,
just to make it 100% clear in their heads.

:-)

Regards and best wishes,

Justin Clift


> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi