Re: Bitmap scan when it is not needed

From: Tom Lane
Subject: Re: Bitmap scan when it is not needed
Date: ,
Msg-id: 28244.1125269347@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Bitmap scan when it is not needed  ("Ilia Kantor")
List: pgsql-performance

"Ilia Kantor" <> 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


pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: Bitmap scan when it is not needed
From: Carlos Henrique Reimer
Date:
Subject: shared buffers