Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;
Дата
Msg-id 18517.983378938@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;  ("Rod Taylor" <rod.taylor@inquent.com>)
Список pgsql-general
Дерево обсуждения 
"Rod Taylor" <rod.taylor@inquent.com> writes:
> Query on 7.0 on Ultra II took over 5 hours.  Query on 7.1 on x86 took
> under 10 seconds.  Same data.

Good ... I guess, because I'm not sure why the difference.  We haven't
done very much in the optimizer since 7.0.  What are the full
declarations of these tables and their indexes?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: trouble configuring Postgres with Identd authentication
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [ANNOUNCE] Addison-Wesley looking for authors