Re: [HACKERS] queries on 2+ indices

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] queries on 2+ indices
Дата
Msg-id 4520.950918418@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] queries on 2+ indices  (Marc Tardif <admin@wtbwts.com>)
Список pgsql-hackers
Marc Tardif <admin@wtbwts.com> writes:
> I'm not sure I understand what is "qpqual" in your explanation. Once the
> first indexscan is performed, is a temporary table created (in-file or
> in-memory) containing the relevant tuples?

No, it's all done on-the-fly as each tuple is scanned.

> is the remaining part of the WHERE
> clause re-evaluated again and again for each of the found tuples in the
> first indexscan?

That's what I said.
        regards, tom lane


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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: SQL compliance - why -- comments only at psql level ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is it a bug?