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 92EAF8B9CEF for ; Wed, 23 Feb 2005 01:03:56 +0000 (GMT) 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 77079-10 for ; Wed, 23 Feb 2005 01:03:46 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id F34618B9BBF for ; Wed, 23 Feb 2005 01:03:48 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 14E8B31474; Wed, 23 Feb 2005 02:03:48 +0100 (MET) From: Gaetano Mendola X-Newsgroups: pgsql.performance Subject: Re: is pg_autovacuum so effective ? Date: Wed, 23 Feb 2005 02:03:10 +0100 Organization: Hub.Org Networking Services Lines: 38 Message-ID: <421BD64E.30803@bigfoot.com> References: <12400.1109107683@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Tom Lane User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en In-Reply-To: <12400.1109107683@sss.pgh.pa.us> X-Enigmail-Version: 0.90.1.1 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/303 X-Sequence-Number: 10632 Tom Lane wrote: > Gaetano Mendola writes: > >>I'm using ony pg_autovacuum. I expect that disk usage will reach >>a steady state but is not. PG engine: 7.4.5 > > > One data point doesn't prove that you're not at a steady state. I do a graph about my disk usage and it's a ramp since one week, I'll continue to wait in order to see if it will decrease. I was expecting the steady state at something like 4 GB ( after a full vacuum and reindex ) + 10 % = 4.4 GB I'm at 4.6 GB and increasing. I'll see how it will continue. >># vacuum full verbose messages; >>INFO: vacuuming "public.messages" >>INFO: "messages": found 77447 removable, 1606437 nonremovable row versions in 69504 pages >>... >>INFO: "messages": moved 55221 row versions, truncated 69504 to 63307 pages > > > 10% overhead sounds fairly reasonable to me. How does that compare to > the amount of updating you do on the table --- ie, do you turn over 10% > of the table in a day? Less, that table have 1.6 milion rows, and I insert 2000 rows in a day with almost ~ 40000 update in one day. So it's something like: 2.5 % Regards Gaetano Mendola