Re: Simple postgresql.conf wizard

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Simple postgresql.conf wizard
Дата
Msg-id 491C761A.4030100@agliodbs.com
обсуждение исходный текст
Ответ на Re: Simple postgresql.conf wizard  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: Simple postgresql.conf wizard  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Simple postgresql.conf wizard  (Greg Stark <greg.stark@enterprisedb.com>)
Список pgsql-hackers
Gregory Stark wrote:
> Josh Berkus <josh@agliodbs.com> writes:
> 
>> DW:
>>     default_statistics_target = 400
>> Mixed:
>>     default_statistics_target = 100
> 
> You, my friend, are certifiably insane.

Hmmm?  Why?  I've used those settings in the field, fairly frequently. 
I was actually wondering if we should raise the default for web as well, 
but decided to let it alone.

Actually, I think a DW should begin at 400; often it needs to go up to 
1000, but I don't think a script should do that.

--Josh



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Block-level CRC checks
Следующее
От: Decibel!
Дата:
Сообщение: Re: WIP: Automatic view update rules