Re: [HACKERS] Old-style OR indexscan slated for destruction

2005-04-24 Thread Christopher Kings-Lynne
For all index types? Even lossy ones? Can't see that a lossy index would make any difference ... OK, was just checking :) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's dataty

Re: [HACKERS] Old-style OR indexscan slated for destruction

2005-04-24 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > 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

Re: [HACKERS] Old-style OR indexscan slated for destruction

2005-04-24 Thread Christopher Kings-Lynne
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 acce

Re: [HACKERS] Old-style OR indexscan slated for destruction

2005-04-24 Thread Oleg Bartunov
On Sun, 24 Apr 2005, Tom Lane wrote: 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