X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 37C02D7D91 for ; Wed, 12 Oct 2005 12:12:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38486-05 for ; Wed, 12 Oct 2005 15:12:22 +0000 (GMT) Received: from mail.baymountain.com (mail.baymountain.com [8.7.96.19]) by svr1.postgresql.org (Postfix) with SMTP id 8F955D7DE6 for ; Wed, 12 Oct 2005 12:12:19 -0300 (ADT) Received: (qmail 27868 invoked by uid 504); 12 Oct 2005 15:12:17 -0000 Received: from emil@baymountain.com by mail.baymountain.com by uid 501 with qmail-scanner-1.16 (spamassassin: 2.53. Clear:SA:0(0.0/7.0):. Processed in 0.244036 secs); 12 Oct 2005 15:12:17 -0000 Received: from unknown (HELO briggspack.com) (emil@briggspack.com@24.211.148.77) by mail.baymountain.com with SMTP; 12 Oct 2005 15:12:17 -0000 From: Emil Briggs Reply-To: emil@baymountain.com To: pgsql-performance@postgresql.org Subject: Re: Help tuning postgres Date: Wed, 12 Oct 2005 11:12:11 -0400 User-Agent: KMail/1.7.1 References: <1129128315.2995.174.camel@coppola.muc.ecircle.de> In-Reply-To: <1129128315.2995.174.camel@coppola.muc.ecircle.de> Organization: Baymountain, Inc. MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200510121112.11486.emil@baymountain.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.038 required=5 tests=[AWL=-0.012, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/208 X-Sequence-Number: 14976 > Hi all, > > After a long time of reading the general list it's time to subscribe to > this one... > > We have adapted our application (originally written for oracle) to > postgres, and switched part of our business to a postgres data base. > > The data base has in the main tables around 150 million rows, the whole > data set takes ~ 30G after the initial migration. After ~ a month of > usage that bloated to ~ 100G. We installed autovacuum after ~ 2 weeks. > Have you tried reindexing your active tables? Emil