Re: Simple postgresql.conf wizard

On Wed, 2008-12-03 at 15:21 -0500, Robert Haas wrote:
> >> I'm not sure what "mixed" mode is supposed to be, but based on what
> >> I've seen so far, I'm a skeptical of the idea that encouraging people
> >> to raise default_statistics_target to 50 and turn on
> >> constraint_exclusion is reasonable.
> >
> > Why?
> 
> Because both of those settings are strictly worse for my database than

I can see an argument about constraint_exclusion but
default_statistics_target I don't.

> the defaults.  I don't have any partitioned tables, and see:
> 
> http://archives.postgresql.org/pgsql-hackers/2008-11/msg01837.php
> >
> > What does checkpoint_segments have to do with the size of the database?
> 
> It seems unlikely that you would want 256 MB of checkpoint segments on
> a database that is only 100 MB (or even 500 MB).  But you might very
> well want that on a database that is 1 TB.

It also seems unlikely that you would hit 256MB of checkpoint segments
on a 100MB database before checkpoint_timeout and if you did, you
certainly did need them.

Remember postgresql only creates the segments when it needs them. 

Sincerely,

Joshua D. Drake


> 
> ...Robert
> 
-- 
PostgreSQL  Consulting, Development, Support, Training  503-667-4564 - http://www.commandprompt.com/  The PostgreSQL
Company,serving since 1997