Re: Simple postgresql.conf wizard - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Simple postgresql.conf wizard
Date
Msg-id 603c8f070812031337q16a6ff42p48a0eb189cae12bd@mail.gmail.com
Whole thread Raw
In response to Re: Simple postgresql.conf wizard  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Simple postgresql.conf wizard  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
> I can see an argument about constraint_exclusion but
> default_statistics_target I don't.

Why not?  I don't want to accept a big increase in ANALYZE times (or
planning times, though I'm really not seeing that at this point)
without some benefit.

>> 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.

So why do we have this parameter at all?

...Robert


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Simple postgresql.conf wizard
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Simple postgresql.conf wizard