Re: Proper Sizing of Shared Buffer Cache

Don Kelloway wrote:
> I'm a first-time user with PostgreSQL so please forgive my ignorance.
>
> I've purchased (and read) Practical PostgreSQL (O'Reilly) and PostgreSQL
> Essential Reference (New Riders). So far, so good. I think learning
> PostgreSQL will not be as difficult as I thought it would be. I've also
> been googling for the last few days, but I have a question in regards to
> determining the proper size of the buffer cache parameter.

Another good reference point is
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

The only real way to find the best value is by testing different values
against actual usage.

There's also a performance mailing list you might find useful. Archive
available on the website.
--
Richard Huxton
Archonet Ltd