Old-style OR indexscan slated for destruction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Old-style OR indexscan slated for destruction
Date: 2005-04-24 18:41:41
Message-ID: 17986.1114368101@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2005-04-24 18:52:55 Re: W[i/e]rd performance issue with 8.1cvs
Previous Message Josh Berkus 2005-04-24 18:30:50 Re: [HACKERS] Bad n_distinct estimation; hacks suggested?