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

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Дата
Msg-id 200504231653.16317.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Bad n_distinct estimation; hacks suggested?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
People,

> Can someone whose math is more recent than calculus in 1989 take a look at
> that paper, and look at the formula toward the bottom of page 10, and see
> if we are correctly interpreting it?    I'm particularly confused as to
> what "q" and "d-sub-n" represent.  Thanks!

Actually, I managed to solve for these and it appears we are using the formula
correctly.  It's just a bad formula.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Следующее
От: "Andrew Dunstan"
Дата:
Сообщение: Re: [PERFORM] Bad n_distinct estimation; hacks suggested?