X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1E5CFD1B8C0; Wed, 3 Sep 2003 19:16:59 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 33066-07; Wed, 3 Sep 2003 16:16:28 -0300 (ADT) Received: from host2.hostseguro.com (unknown [200.198.188.133]) by svr1.postgresql.org (Postfix) with ESMTP id B9D50D1B89D; Wed, 3 Sep 2003 16:16:25 -0300 (ADT) Received: from cpanel by host2.hostseguro.com with local (Exim 4.20) id 19ud6k-000816-Dr; Wed, 03 Sep 2003 16:15:58 -0300 Received: from 200.203.32.16 ([200.203.32.16]) by sistemica.info (IMP) with HTTP for ; Wed, 3 Sep 2003 16:15:58 -0300 Message-ID: <1062616558.3f563dee5ccd4@sistemica.info> Date: Wed, 3 Sep 2003 16:15:58 -0300 From: Rhaoni Chiu Pereira To: PostgreSQL Performance , Lista PostgreSQL Subject: SQL slower when running for the second time MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 200.203.32.16 X-MailScanner-Information: Verificado pelo McAfee VirusScan / Scanned by McAfee VirusScan X-MailScanner: Nao infectado / Found to be clean X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - host2.hostseguro.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [32001 32001] / [47 12] X-AntiAbuse: Sender Address Domain - sistemica.info X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/39 X-Sequence-Number: 10127 Hi List, I trying to increase performance in my PostgreSQL but there is something wrong. when I run this SQL for the first time it takes 1 min. 40 seconds to return, but when I run it for the second time it takes more than 2 minutes, and I should retunr faster than the first time. Does anyone have a advice ? Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122