Re: Maximum statistics target

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Maximum statistics target
Дата
Msg-id 20080307184157.GA23644@svana.org
обсуждение исходный текст
Ответ на Maximum statistics target  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Maximum statistics target  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, Mar 07, 2008 at 07:25:25PM +0100, Peter Eisentraut wrote:
> What's the problem with setting it to ten million if I have ten million values
> in the table and I am prepared to spend the resources to maintain those
> statistics?

That it'll probably take 10 million seconds to calculate the plans
using it? I think Tom pointed there are a few places that are O(n^2)
the number entries...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

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

Предыдущее
От: Andrew Chernow
Дата:
Сообщение: Re: Commitfest status
Следующее
От: Aidan Van Dyk
Дата:
Сообщение: Re: Commitfest status