Re: [PATCHES] Better default_statistics_target

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: [PATCHES] Better default_statistics_target
Дата
Msg-id 200801312319.59723.xzilla@users.sourceforge.net
обсуждение исходный текст
Ответ на Re: [PATCHES] Better default_statistics_target  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: [PATCHES] Better default_statistics_target
Список pgsql-hackers
On Thursday 31 January 2008 09:55, Kevin Grittner wrote:
> >>> On Wed, Jan 30, 2008 at  8:13 PM, in message
>
> <d6d6637f0801301813n64fa58eu76385cf8a621907@mail.gmail.com>, "Christopher
>
> Browne" <cbbrowne@gmail.com> wrote:
> > There seems to be *plenty* of evidence out there that the performance
> > penalty would NOT be "essentially zero."
>
> I can confirm that I have had performance tank because of boosting
> the statistics target for selected columns.  It appeared to be time
> spent in the planning phase, not a bad plan choice.  Reducing the
> numbers restored decent performance.
>

Bad plans from boosting to 100 or less? Or something much higher? 


-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL


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

Предыдущее
От: "Roberts, Jon"
Дата:
Сообщение: Re: timestamp format bug
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: [Fwd: [COMMITTERS] pgsql: Stamp 8.3 in CVS.]