Re: Why is query selecting sequential?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Why is query selecting sequential?
Дата
Msg-id 200402082134.18156.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Why is query selecting sequential?  (Karl Denninger <karl@denninger.net>)
Список pgsql-performance
Дерево обсуждения 
Karl,

> BTW, the other posted "cleaner" model doesn't work for me.  If there is NO
> row in the subtable that matches, the other version returns nothing (which
> makes sense since the initial select fails to match any rows as one of the
> things its trying to match is missing.)

Ah, wasn't thinking of that case.    Problem with not really knowing what the
database is about.

--
Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: RE : RE : Increase performance of a UNION query that
Следующее
От: David Teran
Дата:
Сообщение: select count(*) from anIntColumn where int_value = 0; is very slow