X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A733BD6ECD
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun, 28 Aug 2005 19:49:10 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 16343-03
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun, 28 Aug 2005 22:49:08 +0000 (GMT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 346E8D6EA0
	for <pgsql-performance@postgresql.org>;
	Sun, 28 Aug 2005 19:49:07 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7SMn7MZ028245;
	Sun, 28 Aug 2005 18:49:08 -0400 (EDT)
To: "Ilia Kantor" <ilia@obnovlenie.ru>
Cc: pgsql-performance@postgresql.org
Subject: Re: Bitmap scan when it is not needed 
In-reply-to: <auto-000558491990@umail.ru> 
References: <auto-000558491990@umail.ru>
Comments: In-reply-to "Ilia Kantor" <ilia@obnovlenie.ru>
	message dated "Mon, 29 Aug 2005 00:48:40 +0400"
Date: Sun, 28 Aug 2005 18:49:07 -0400
Message-ID: <28244.1125269347@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level: 
X-Archive-Number: 200508/492
X-Sequence-Number: 14239

"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