X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5346E528CB for ; Fri, 3 Jun 2005 00:36:28 -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 14000-03 for ; Fri, 3 Jun 2005 03:36:19 +0000 (GMT) Received: from snappy.tocr.com (snappy.tocr.com [64.34.164.72]) by svr1.postgresql.org (Postfix) with ESMTP id 0132B52851 for ; Fri, 3 Jun 2005 00:36:16 -0300 (ADT) Received: by snappy.tocr.com (Postfix, from userid 48) id 3F56895026F; Thu, 2 Jun 2005 23:38:18 -0400 (EDT) Received: from 68.175.84.212 (SquirrelMail authenticated user matthew) by mail.tocr.com with HTTP; Thu, 2 Jun 2005 23:38:18 -0400 (EDT) Message-ID: <31520.68.175.84.212.1117769898.squirrel@mail.tocr.com> In-Reply-To: <14703.1117728639@sss.pgh.pa.us> References: <00d501c5667d$8cc12320$f20214ac@bite.lt> <13878.1117636799@sss.pgh.pa.us> <018601c56744$9d5aae50$f20214ac@bite.lt> <13178.1117719939@sss.pgh.pa.us> <02db01c5677e$d43d3b10$f20214ac@bite.lt> <14703.1117728639@sss.pgh.pa.us> Date: Thu, 2 Jun 2005 23:38:18 -0400 (EDT) Subject: Re: How to avoid database bloat From: matthew@tocr.com To: "Tom Lane" Cc: "Mindaugas Riauba" , pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.4-1.FC2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200506/97 X-Sequence-Number: 12735 > "Mindaugas Riauba" writes: >> And what in vacuum verbose output suggests that vacuum is not done >> often enough? Current output (table is 100MB already) is below. > > The output shows vacuum cleaning up about a third of the table. Usually > people like to keep the overhead down to 10% or so ... He was running with -V 0.5 which should transalate to roughly 50% of the table being touched before a vacuum is issued.j Matt