Re: Revisiting default_statistics_target

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Revisiting default_statistics_target
Дата
Msg-id 1243013948.16418.864.camel@jd-laptop.pragmaticzealot.org
обсуждение исходный текст
Ответ на Re: Revisiting default_statistics_target  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Revisiting default_statistics_target  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, 2009-05-22 at 13:35 -0400, Stephen Frost wrote:
> Greg,

> dbt-2 is for OLTP, not for DW.  Greg Smith's comment was actually that
> we shouldn't penalize the OLTP crowd (by raising the value) for the
> benefit of the DW crowd (who need it higher than 100 anyway).
> 

I appear to have completely missed the top part of Greg Smith's original
email. Sorry about that Greg.

We probably need to test this to get some more data points. Of course
that is why we have the performance lab :)

Joshua D. Drake

-- 
PostgreSQL - XMPP: jdrake@jabber.postgresql.org  Consulting, Development, Support, Training  503-667-4564 -
http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997
 



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Revisiting default_statistics_target
Следующее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: Revisiting default_statistics_target