Re: [PERFORM] Query Plan - Bitmap Index Scan and Views

Rusty Conover <[EMAIL PROTECTED]> writes: > Absolutely, I'll attempt to run the test against the current CVS HEAD. > Do I need to pg_dump and restore from 8.1.4? Yup, fraid so. regards, tom lane ---(end of broadcast)--- TIP

Re: [PERFORM] Query Plan - Bitmap Index Scan and Views

On Aug 4, 2006, at 8:15 PM, Tom Lane wrote:Rusty Conover <[EMAIL PROTECTED]> writes: Is there any inherent benefit of using a the IN operator versus  joining a temporary table? Should they offer near equal performance?   It appears bitmap scan's aren't done when matching across a small  temporary t

Re: [PERFORM] Query Plan - Bitmap Index Scan and Views

Rusty Conover <[EMAIL PROTECTED]> writes: > Is there any inherent benefit of using a the IN operator versus > joining a temporary table? Should they offer near equal performance? > It appears bitmap scan's aren't done when matching across a small > temporary table. I believe the problem you

[PERFORM] Query Plan - Bitmap Index Scan and Views

Hi, Is there any inherent benefit of using a the IN operator versus joining a temporary table? Should they offer near equal performance? It appears bitmap scan's aren't done when matching across a small temporary table. I have a temporary table with 5 integers in it that I'm matching a