X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1787211F653F for ; Sun, 9 Apr 2006 17:45:02 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.246 X-Spam-Level: X-Spam-Status: No, score=0.246 required=5 tests=[AWL=0.057, MISSING_HEADERS=0.189] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id JKqS7BHYFN2w for ; Sun, 9 Apr 2006 17:44:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from zeus.gigaweb.cz (zeus.gigaweb.cz [81.0.236.19]) by postgresql.org (Postfix) with SMTP id 61F1111F6379 for ; Sun, 9 Apr 2006 17:44:54 -0300 (ADT) Received: (qmail 29605 invoked from network); 9 Apr 2006 20:44:55 -0000 Received: from unknown (HELO ?192.168.1.101?) (89.102.142.167) by 0 with SMTP; 9 Apr 2006 20:44:55 -0000 Message-ID: <44397243.6010208@fuzzy.cz> Date: Sun, 09 Apr 2006 22:44:51 +0200 From: Tomas Vondra User-Agent: Mail/News 1.5 (X11/20060131) MIME-Version: 1.0 CC: pgsql-performance@postgresql.org Subject: Re: serious problems with vacuuming databases References: <443950FB.4050707@fuzzy.cz> <20060409183747.GB15094@surnet.cl> <44397071.80008@fuzzy.cz> In-Reply-To: <44397071.80008@fuzzy.cz> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Archive-Number: 200604/183 X-Sequence-Number: 18267 > I guess you're right. I forgot to mention there are 12 composed indexes > on the largest (and not deleted) table B, having about 14.000.000 rows > and 1 GB of data. I'll try to dump/reload the database ... Aaargh, the problem probably is not caused by the largest table, as it was dropped, filled in with the data and after that all the indexes were created. The problem could be caused by the tables with deleted data, of course. t.v.