Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 751459FB5BD for ; Wed, 24 Jan 2007 04:54:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 83713-03 for ; Wed, 24 Jan 2007 04:54:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id C37359FB588 for ; Wed, 24 Jan 2007 04:54:06 -0400 (AST) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id CD7B673DDA; Wed, 24 Jan 2007 08:54:05 +0000 (GMT) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id B26682742B6; Wed, 24 Jan 2007 08:54:05 +0000 (GMT) Message-ID: <45B71EAD.7060301@archonet.com> Date: Wed, 24 Jan 2007 08:54:05 +0000 From: Richard Huxton User-Agent: IceDove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: Gauri Kanekar Cc: pgsql-performance@postgresql.org Subject: Re: Auto Vacuum Problem References: <7e4ba9550701240049w22e65273s3dc8ba58a9a735b@mail.gmail.com> In-Reply-To: <7e4ba9550701240049w22e65273s3dc8ba58a9a735b@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/362 X-Sequence-Number: 22963 Gauri Kanekar wrote: > Hi List, > > When auto vacuum is over the dead tuple are seems to get reduced, but > physical size of database do not decreases. It won't necessarily. An ordinary vacuum just keeps track of old rows that can be cleared and re-used. A "vacuum full" is needed to compact the table. If you are running a normal vacuum often enough then the size of the database should remain about the same (unless you insert more rows of course). -- Richard Huxton Archonet Ltd