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
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
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
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