X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 269489F931E for ; Mon, 8 May 2006 16:43:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 79727-09 for ; Mon, 8 May 2006 16:43:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from rwcrmhc13.comcast.net (rwcrmhc13.comcast.net [204.127.192.83]) by postgresql.org (Postfix) with ESMTP id 5C3049F931D for ; Mon, 8 May 2006 16:43:41 -0300 (ADT) Received: from [192.168.1.52] (c-65-96-235-5.hsd1.ma.comcast.net[65.96.235.5]) by comcast.net (rwcrmhc13) with ESMTP id <20060508194340m1300pc0bse>; Mon, 8 May 2006 19:43:40 +0000 Message-ID: <445F9F6B.9040200@comcast.net> Date: Mon, 08 May 2006 15:43:39 -0400 From: Jeffrey Tenny User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: "Jim C. Nasby" CC: pgsql-performance@postgresql.org Subject: Re: performance question (something to do w/ parameterized References: <445F7FF8.6070707@comcast.net> <20060508173812.GW99570@pervasive.com> In-Reply-To: <20060508173812.GW99570@pervasive.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/150 X-Sequence-Number: 18937 Well, since I don't know the exact parameter values, just substituting 1-650 for $1-$650, I get: Index Scan using testindex2 on x (cost=0.00..34964.52 rows=1503 width=16) (actual time=0.201..968.252 rows=677 loops=1) Filter: ((f = 1) OR (f = 2) OR (f = 3) OR (f = 4) ... So index usage is presumably good on this one. Jim C. Nasby wrote: > What's EXPLAIN ANALYZE show? >