Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7E8102E020D for ; Tue, 11 Dec 2007 15:46:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 72678-01-4 for ; Tue, 11 Dec 2007 15:46:21 -0400 (AST) Received: from web36215.mail.mud.yahoo.com (web36215.mail.mud.yahoo.com [209.191.68.241]) by postgresql.org (Postfix) with SMTP id C763F2E333C for ; Tue, 11 Dec 2007 15:46:03 -0400 (AST) Received: (qmail 6572 invoked by uid 60001); 11 Dec 2007 19:46:01 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=wAWz/DBy/dZYyHfKuLXA6tns7OQEQOpNQE2TQiaIe7nT6mFelJyRzPdEQaklm5CrCLfJzJqefNVehSnn6SbqdZFtEdxNslaTH3Pn5kOTk3zx0rcOecv86DlcpPI6YCWlXNqMl++2WON5nJ/UQcyp0UWfEN78i2pzKO1Uo4u4luo=; X-YMail-OSG: SHtmoDIVM1mh2yGBNqungJU9CVOr7GUTyBQmjpK1CntrbQoJzKYvNuqGYsq9UIedbYCGAJtCvLQl24h_QT5NVygBW7in_Q8xUSnueoxABlBuDlfRuESOg_5y.g.lNg-- Received: from [200.250.55.253] by web36215.mail.mud.yahoo.com via HTTP; Tue, 11 Dec 2007 16:46:01 ART Date: Tue, 11 Dec 2007 16:46:01 -0300 (ART) From: "A.Burbello" Subject: improve performance in a big table To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <222808.5599.qm@web36215.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200712/54 X-Sequence-Number: 27571 Hi people, I have a case and I got a doubt what should be the best ways. One table has more than 150 million of rows, and I thought that could divided by state. For each row has person ID, state and other informations, but the search would be done only by person ID (number column). I can improve the query by putting index in that column, but is there any other ways? Thank you. Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/