Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 8D1B69FB5C8 for ; Wed, 24 Jan 2007 04:49:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 22931-08 for ; Wed, 24 Jan 2007 04:49:04 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id 5551B9FB588 for ; Wed, 24 Jan 2007 04:49:07 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so131253wxd for ; Wed, 24 Jan 2007 00:49:06 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=EpRvWslWAAZ/sCpNsNYUrAXwAySQUSiVnz3ximrhIuJySNhyae0DpMHj52KoH+E7MnAQLJHHRlA6vxFBv7HmlpTG2mFbuXXABKQE6jMyTKJSogy0231JzC4Baf/bRGmv96SOgnmC3QyRgL+ie3B1+Jp2CQh1IgTGsgg2+ygsCGc= Received: by 10.90.56.14 with SMTP id e14mr274301aga.1169628546670; Wed, 24 Jan 2007 00:49:06 -0800 (PST) Received: by 10.90.73.13 with HTTP; Wed, 24 Jan 2007 00:49:06 -0800 (PST) Message-ID: <7e4ba9550701240049w22e65273s3dc8ba58a9a735b@mail.gmail.com> Date: Wed, 24 Jan 2007 14:19:06 +0530 From: "Gauri Kanekar" To: pgsql-performance@postgresql.org Subject: Auto Vacuum Problem MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1892_12862468.1169628546631" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/360 X-Sequence-Number: 22961 ------=_Part_1892_12862468.1169628546631 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi List, When auto vacuum is over the dead tuple are seems to get reduced, but physical size of database do not decreases. We are using Postgres 8.1.3 and this are the auto vacuum settings. autovacuum = on # enable autovacuum subprocess? autovacuum_naptime = 900 # time between autovacuum runs, in secs autovacuum_vacuum_scale_factor = 0.1 # fraction of rel size before autovacuum_analyze_scale_factor = 0.05 # fraction of rel size before autovacuum_vacuum_cost_delay = 100 # default vacuum cost delay for How do I make the physical size of the DB smaller without doing a full vacuum. Can anybody help me out in this. -- Regards Gauri ------=_Part_1892_12862468.1169628546631 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi List,
 
When auto vacuum is over the dead tuple are seems to get reduced, but physical size of database do not decreases.
We are using Postgres 8.1.3 and this are the auto vacuum settings.
 
autovacuum = on                 # enable autovacuum subprocess?
autovacuum_naptime = 900                # time between autovacuum runs, in secs
autovacuum_vacuum_scale_factor = 0.1    # fraction of rel size before
autovacuum_analyze_scale_factor = 0.05  # fraction of rel size before
autovacuum_vacuum_cost_delay = 100      # default vacuum cost delay for
How do I make the physical size of the DB smaller without doing a full vacuum.
 
Can anybody help me out in this.
 
--
Regards
Gauri
------=_Part_1892_12862468.1169628546631--