Postgres Pro
Downloads
Home   >   mailing lists

Re: Using bitmap index scans-more efficient - Mailing list pgsql-sql

From Tom Lane
Subject Re: Using bitmap index scans-more efficient
Date
Msg-id 26676.1155747492@sss.pgh.pa.us
Whole thread Raw
In response to Using bitmap index scans-more efficient  (Kyle Bateman <kyle@actarg.com>)
Responses Re: Using bitmap index scans-more efficient  (Kyle Bateman <kyle@actarg.com>)
List pgsql-sql
Tree view 
Kyle Bateman <kyle@actarg.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

pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: problem with sequence.....
Next
From: "Rodrigo De León"
Date:
Subject: Re: Undo an update