Re: intersect performance (PG 7.1.3 vs 7.2)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: intersect performance (PG 7.1.3 vs 7.2)
Дата
Msg-id 25651.1018107935@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: intersect performance (PG 7.1.3 vs 7.2)  (d_nardini@btconnect.com)
Список pgsql-sql
d_nardini@btconnect.com writes:
> Following are EXPLAIN dumps from each platform for both intersect and 
> union (both return the correct data on each platform).

Did you ever VACUUM ANALYZE these tables on the 7.1 box?  The statistics
estimates from that machine look suspiciously like default values.

If you did, then maybe I can credit 7.2's improved statistics machinery
with a win ;-).  But I bet the better choice of plan on the 7.2 box is
due simply to having any stats at all.

Can't help you with the RPM dependency issues, sorry.
        regards, tom lane


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

Предыдущее
От: d_nardini@btconnect.com
Дата:
Сообщение: Re: intersect performance (PG 7.1.3 vs 7.2)
Следующее
От: Frank Joerdens
Дата:
Сообщение: Re: Rule trouble (looks to me exactly like the example)