Does FILTER in SEQSCAN short-circuit AND?

Поиск
Список
Период
Сортировка
От Carlo Stonebanks
Тема Does FILTER in SEQSCAN short-circuit AND?
Дата
Msg-id hsv49v$312j$1@news.hub.org
обсуждение исходный текст
Ответы Re: Does FILTER in SEQSCAN short-circuit AND?
Re: Does FILTER in SEQSCAN short-circuit AND?
Список pgsql-performance
Sample code:

SELECT *
FROM MyTable
WHERE foo = 'bar' AND MySlowFunc('foo') = 'bar'

Let's say this required a SEQSCAN because there were no indexes to support
column foo. For every row where foo <> 'bar' would the filter on the SEQSCAN
short-circuit the AND return false right away, or would it still execute
MySlowFunc('foo') ?

Thanks!

Carlo


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

Предыдущее
От: Cédric Villemain
Дата:
Сообщение: Re: Random Page Cost and Planner
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Does FILTER in SEQSCAN short-circuit AND?