From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Greg Smith <greg(at)2ndquadrant(dot)com> |
Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: shared_buffers documentation |
Date: | 2010-04-19 01:08:21 |
Message-ID: | x2s603c8f071004181808gfdd85835z8743d4bed7cbbbd2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Apr 14, 2010 at 4:18 PM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> As for updating the size recommendations, the text at
> http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server has been
> beaten into the status quo by a number of people.
A few other random thoughts on this document:
1. The section on default_statistics_target needs some updating - the
default is 100 in 8.4+.
2. Reading the section on checkpoint_segments reminds me, again, that
the current value seems extremely conservative on modern hardware.
It's quite easy to hit this when doing large bulk data loads or even a
big ol' CTAS. I think we should consider raising this for 9.1. I
don't have a real strong opinion on what we should raise it TO - I
think it's basically a question of how much temporary disk storage we
think we can use during a large bulk data load without having users
come back and say "wtf?" - but it seems to me that we're not doing
ourselves any favors by having this set to a value where the first
advice we give our users is "try tripling it".
...Robert
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2010-04-19 01:58:05 | Re: master in standby mode croaks |
Previous Message | Robert Haas | 2010-04-19 00:55:58 | Re: enable_material patch |