Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 89CEC9FA4C2 for ; Sat, 28 Jul 2007 16:51:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 56854-04 for ; Sat, 28 Jul 2007 16:51:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.emolecules.com (66-226-76-106.dedicated.abac.net [66.226.76.106]) by postgresql.org (Postfix) with ESMTP id 0C8FE9FA4BB for ; Sat, 28 Jul 2007 16:51:42 -0300 (ADT) Received: (qmail 3444 invoked by uid 2020); 28 Jul 2007 12:52:06 -0700 Received: from wsip-68-224-174-233.sd.sd.cox.net (HELO ?192.168.0.3?) (68.224.174.233) by 192.168.0.4 with SMTP; 28 Jul 2007 12:52:06 -0700 Message-ID: <46ABA01E.8000802@emolecules.com> Date: Sat, 28 Jul 2007 12:59:26 -0700 From: Craig James User-Agent: Thunderbird 1.5.0.12 (X11/20070509) MIME-Version: 1.0 To: Bruno Rodrigues Siqueira , pgsql-performance@postgresql.org Subject: Re: select on 1milion register = 6s References: <000c01c7d14d$4df223f0$e900a8c0@brunolaptop> In-Reply-To: <000c01c7d14d$4df223f0$e900a8c0@brunolaptop> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.23 tagged_above=0 required=5 tests=AWL=0.129, BAYES_50=0.001, RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200707/399 X-Sequence-Number: 26083 Bruno Rodrigues Siqueira wrote: > Who can help me? My SELECT in a base with 1 milion register, > using expression index = 6seconds… Run your query using EXPLAIN ANALYZE SELECT ... your query ... and then post the results to this newsgroup. Nobody can help until they see the results of EXPLAIN ANALYZE. Also, include all other relevant information, such as Postgres version, operating system, amount of memory, and any changes you have made to the Postgres configuration file. Craig