"Ilia Kantor" <[EMAIL PROTECTED]> 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 ... s
explain analyze select * from objects_hier where tg
&& array[0] and id <1;
Bitmap Heap Scan on objects_hier
(cost=4.79..8.80 rows=1 width=337) (actual time=0.110..0.110 rows=0 loops=1)
Recheck Cond: ((tg &&
'{0}'::integer[]) AND (id < 1))
-> BitmapAnd
(cost=4.79..4.79
