Re: [HACKERS] queries on 2+ indices

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Tardif <admin(at)wtbwts(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] queries on 2+ indices
Date: 2000-02-19 00:00:18
Message-ID: 4520.950918418@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Marc Tardif <admin(at)wtbwts(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-02-19 00:14:51 Re: Is it a bug?
Previous Message Hannu Krosing 2000-02-18 23:36:38 Re: SQL compliance - why -- comments only at psql level ?