Re: [PERFORM] Bad n_distinct estimation; hacks suggested?

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Дата
Msg-id 1114557011.77587.107.camel@home
обсуждение исходный текст
Ответ на Re: [PERFORM] Bad n_distinct estimation; hacks suggested?  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Дерево обсуждения 
On Tue, 2005-04-26 at 19:03 -0400, Greg Stark wrote:
> This one looks *really* good. 
> 
>  http://www.aladdin.cs.cmu.edu/papers/pdfs/y2001/dist_sampl.pdf
> 
> It does require a single full table scan 

Ack.. Not by default please.

I have a few large append-only tables (vacuum isn't necessary) which do
need stats rebuilt periodically.

Lets just say that we've been working hard to upgrade to 8.0 primarily
because pg_dump was taking over 18 hours to make a backup.

-- 
Rod Taylor <rbt@sitesell.com>

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

Предыдущее
От: "Dave Held"
Дата:
Сообщение: Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Следующее
От: Brent Verner
Дата:
Сообщение: Re: [proposal] protocol extension to support loadable stream filters