Old-style OR indexscan slated for destruction - Mailing list pgsql-hackers

From Tom Lane
Subject Old-style OR indexscan slated for destruction
Date
Msg-id 17986.1114368101@sss.pgh.pa.us
Whole thread Raw
Responses Re: Old-style OR indexscan slated for destruction
List pgsql-hackers
I am about to rip out the code that supports multiple indexscans for OR
conditions inside a single IndexScan plan node.  As best I can tell,
the new-style bitmap-OR code is as fast or faster than the old way
even in fully cached test cases (ie, with no allowance for improved
efficiency of disk access).  So there's no percentage in maintaining
support for the old way, and getting rid of it will allow simplification
of code and data structures in the planner.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Next
From: Josh Berkus
Date:
Subject: Re: W[i/e]rd performance issue with 8.1cvs