Postgres Pro
Downloads
Home   >   mailing lists

Re: Bitmap scan when it is not needed - Mailing list pgsql-performance

From Tom Lane
Subject Re: Bitmap scan when it is not needed
Date
Msg-id 28244.1125269347@sss.pgh.pa.us
Whole thread Raw
In response to Bitmap scan when it is not needed  ("Ilia Kantor" <ilia@obnovlenie.ru>)
List pgsql-performance
Tree view 
"Ilia Kantor" <ilia@obnovlenie.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Planner improvement suggestion
Next
From: Carlos Henrique Reimer
Date:
Subject: shared buffers