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(at)candle(dot)pha(dot)pa(dot)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