Re: Bitmap scan when it is not needed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bitmap scan when it is not needed
Date: 2005-08-28 22:49:07
Message-ID: 28244.1125269347@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Ilia Kantor" <ilia(at)obnovlenie(dot)ru> writes:
> Maybe a quickfix is possible for cases when 0 records is found to stop
> reading other AND elements..

Not sure how useful this will be in practice (since the planner tends
not to bother ANDing unselective indexes at all), but it's easy enough
to do ... so I did it.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rémy Beaumont 2005-08-29 13:42:46 High load and iowait but no disk access
Previous Message Tom Lane 2005-08-28 21:30:48 Re: Planner improvement suggestion