Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group