On Thu, Aug 12, 2010 at 10:53 AM, Greg Smith <greg@xxxxxxxxxxxxxxx> 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.Increasing work_mem is a complex calculation for everyone, not just new users. If it were easy for anyone, we'd just bottle whatever experts do into the software directly. I tried doing a round of that with pgtune, and it's still not quite right yet even after surveying everyone who had an opinion on the subject.
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
