On Mon, Apr 19, 2010 at 5:36 PM, Bruce Momjian <bruce@momjian.us> wrote:
>> I don't actually know what's best. I'm just concerned that we have a
>> default in postgresql.conf and a tuning guide that says "don't do
>> that". Maybe the tuning guide needs to be more nuanced, or maybe
>> postgresql.conf needs to be changed, but it makes no sense to have
>> them saying contradictory things.
>
> The good news about checkpoint_segments is that you get a log file
> warning message if the value should be increased, i.e. you are
> checkpointing often than 30 seconds.
Yeah. I get that warning frequently when I'm creating test tables of
dummy data for PG devel purposes. That's actually the main thing that
makes me think the default may be too low.
...Robert