Re: Using bitmap index scans-more efficient

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kyle Bateman <kyle(at)actarg(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, fweimer(at)bfk(dot)de
Subject: Re: Using bitmap index scans-more efficient
Date: 2006-08-16 16:58:12
Message-ID: 26676.1155747492@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kyle Bateman <kyle(at)actarg(dot)com> writes:
> I'm wondering if this might expose a weakness in the optimizer having to
> do with left joins.

Before 8.2 the optimizer has no ability to rearrange the order of outer
joins. Do you have time to try your test case against CVS HEAD?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jon Horsman 2006-08-16 18:44:58 DB creation script questions
Previous Message Jesper K. Pedersen 2006-08-16 16:12:06 OT: OpenDatabase Model ?