Re: [HACKERS] EXISTS optimization

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: [HACKERS] EXISTS optimization
Дата
Msg-id 20070324130759.GA1089@svana.org
обсуждение исходный текст
Ответ на Re: [HACKERS] EXISTS optimization  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
On Fri, Mar 23, 2007 at 05:30:27PM -0500, Kevin Grittner wrote:
> I don't understand -- TRUE OR UNKNOWN evaluates to TRUE, so why would
> the IN need to continue?  I'm not quite following the rest; could you
> elaborate or give an example?  (Sorry if I'm lagging behind the rest
> of the class here.)

You're right, I'm getting confused with the interaction of NULL and NOT
IN.

The multiple evaluation thing still applies, but that's minor.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Optimization postgresql 8.1.4 FC 6 X64 ?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Optimization postgresql 8.1.4 FC 6 X64 ?