Re: Apparently useless bitmap scans

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Apparently useless bitmap scans
Date: 2007-05-09 14:49:08
Message-ID: 26773.1178722148@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> I'm wondering what it wants to achieve with these three index scans:

See if you still get that with 8.2.4. choose_bitmap_and was fairly far
out in left field before that :-( ... particularly for cases with
partially redundant indexes available.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel Cristian Cruz 2007-05-09 14:51:58 Re: Nested loops overpriced
Previous Message Gregory Stark 2007-05-09 14:34:00 Re: Nested loops overpriced