Re: mis-estimation on data-warehouse aggregate creation

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: mis-estimation on data-warehouse aggregate creation
Дата
Msg-id Pine.BSO.4.56.0411170315050.13112@leary.csoft.net
обсуждение исходный текст
Ответ на Re: mis-estimation on data-warehouse aggregate creation  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance

On Tue, 16 Nov 2004, Simon Riggs wrote:

> The join condition has so many ANDed predicates that we assume that this
> will reduce the selectivity considerably. It does not, and so you pay
> the cost dearly later on.
>

Yes, that makes a lot of sense.  Without some incredibly good cross-column
statistics there is no way it could expect all of the rows to match.
Thanks for the analysis.

Kris Jurka

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: memcached and PostgreSQL
Следующее
От: "David Parker"
Дата:
Сообщение: Re: query plan question