On Thu, Aug 12, 2010 at 10:53 AM, Greg Smith
<greg@2ndquadrant.com> wrote:
If only it were that easy. 25%, but only on a dedicated server, don't go above 8GB, limit to much less than that on Windows, and be extremely careful if you're writing heavily lest large checkpoints squash you. Giving simple advice that people might follow without thinking about actually has some worst-case downsides that are worse than not tuning the server at all. This makes Increasing work_mem is a complex calculation for a new user
trying out PostgreSQL.
Maybe a tabular form would be nice - "work_mem" under a) windows < 8GB b) windows > 8gb c) linux < 8gb d) linux > 8gb e) read-heavy f) write-heavy g)log shipping enabled.... etc etc.
Rinse and repeat for all important parameters - in a wiki, you can do nifty things like add footnotes, etc.
That would be awesome!
-Sandeep