Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id CBBDF7661B7 for ; Thu, 21 Jun 2012 14:03:20 -0300 (ADT) Received: from smtp.01.com ([199.36.142.181]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Shkmr-00076T-GK for pgsql-students@postgresql.org; Thu, 21 Jun 2012 17:03:19 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id A58E22940FC for ; Thu, 21 Jun 2012 12:03:03 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-1.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id doJEQXsudjlY for ; Thu, 21 Jun 2012 12:03:03 -0500 (CDT) Received: from smtp.01.com (localhost.localdomain [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 7F1DA2940FA for ; Thu, 21 Jun 2012 12:03:03 -0500 (CDT) Received: from Sidney-Stratton.local (70-36-143-92.dsl.dynamic.sonic.net [70.36.143.92]) by smtp-out-1.01.com (Postfix) with ESMTPSA id 5CEEA2940F3 for ; Thu, 21 Jun 2012 12:03:03 -0500 (CDT) Message-ID: <4FE353C6.5060401@agliodbs.com> Date: Thu, 21 Jun 2012 10:03:02 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:13.0) Gecko/20120614 Thunderbird/13.0.1 MIME-Version: 1.0 To: pgsql-students@postgresql.org Subject: Re: index scan References: <1340261800.81804.YahooMailNeo@web121401.mail.ne1.yahoo.com> In-Reply-To: <1340261800.81804.YahooMailNeo@web121401.mail.ne1.yahoo.com> X-Enigmail-Version: 1.4.2 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/2 X-Sequence-Number: 229 Amir, > I have problem with EXPLAIN ANALYZE QUERY. > I want to change a plan node, from seq scan to index scan. > But i don't know the methode for it. This is to test your indexing code? Then: SET enable_seqscan = false; -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com