Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 9D8FE2E0115
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 13 Mar 2008 04:21:58 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 78450-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 13 Mar 2008 04:21:55 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from hs-out-0708.google.com (hs-out-0708.google.com
 [64.233.178.251])
	by postgresql.org (Postfix) with ESMTP id CAE122E0112
	for <pgsql-performance@postgresql.org>;
	Thu, 13 Mar 2008 04:21:55 -0300 (ADT)
Received: by hs-out-0708.google.com with SMTP id x43so2991267hsb.3
	for <pgsql-performance@postgresql.org>;
	Thu, 13 Mar 2008 00:21:55 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=lWkCg3OuqPqRwXGibZO6wi9XD93+i5R2jRC8c/P6XKo=;
	b=vyjN6CdMRkSvo4o00X79u7Lgz6GNtv3zhixbPWqT3UXplmwQ9hS01ydD/cKAHD+eXkRzmMNE2CWJWUW4R+nKPPgNsD8CpNkgzoZ/cS8HNDgtrmnQlbrIzWDRv2fWDoQ13sM4bR46ZmtKIxmyj+tqq9D1WTG/4TGogyQle5fqkug=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=bcvsrN4e6y6/b9+Mih9o/CyspL4OR5WP33RPiZjqGoDopWjLVb/43komIehDkitT9MY4Dnsw0albwmrppo+0rXpvv3gF4PyIEV7KcdnGBOMDDx+t+zK64OFEGgMi135uf+R1q9uT9ovvblzBmZBuwLvpZGvTiS8nZAdOblEcGBM=
Received: by 10.114.191.1 with SMTP id o1mr8671975waf.117.1205392914019;
	Thu, 13 Mar 2008 00:21:54 -0700 (PDT)
Received: by 10.114.234.6 with HTTP; Thu, 13 Mar 2008 00:21:54 -0700 (PDT)
Message-ID: <cd233fc30803130021h3dbfdea4m3db755677b2b14a0@mail.gmail.com>
Date: Thu, 13 Mar 2008 12:51:54 +0530
From: "petchimuthu lingam" <spmlingam@gmail.com>
To: pgsql-performance@postgresql.org
Subject: partial index + select query performance
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_14812_29965102.1205392914025"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200803/270
X-Sequence-Number: 29224

------=_Part_14812_29965102.1205392914025
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have created partial index on a field with conditions, if   field _a > 200
and field_a  < 300.

I using the select query with condition as field_a in ( 100, 250, 289,  ),

Will it use the index.



-- 
With Best Regards,
Petchimuthulingam S

------=_Part_14812_29965102.1205392914025
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br>I have created partial index on a field with conditions, if&nbsp;&nbsp; field _a &gt; 200 and field_a&nbsp; &lt; 300. <br><br>I using the select query with condition as field_a in ( 100, 250, 289,&nbsp; ),<br><br>Will it use the index.<br>
<br><br clear="all"><br>-- <br>With Best Regards,<br>Petchimuthulingam S

------=_Part_14812_29965102.1205392914025--