Re: [HACKERS] queries on 2+ indices - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] queries on 2+ indices
Date
Msg-id 4520.950918418@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] queries on 2+ indices  (Marc Tardif <admin@wtbwts.com>)
List 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 by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: SQL compliance - why -- comments only at psql level ?
Next
From: Tom Lane
Date:
Subject: Re: Is it a bug?