Re: Simple postgresql.conf wizard

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Simple postgresql.conf wizard
Дата
Msg-id 603c8f070812031337q16a6ff42p48a0eb189cae12bd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Simple postgresql.conf wizard  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Simple postgresql.conf wizard  ("Joshua D. Drake" <jd@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: "Robert Haas"
Дата:
Сообщение: Re: Simple postgresql.conf wizard
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Simple postgresql.conf wizard