Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id D3D284760C0 for ; Mon, 29 Apr 2002 13:06:57 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 530A7475F1F for ; Mon, 29 Apr 2002 12:46:54 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 40169D5FA; Mon, 29 Apr 2002 09:46:59 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 35C605C01; Mon, 29 Apr 2002 09:46:59 -0700 (PDT) Date: Mon, 29 Apr 2002 09:46:59 -0700 (PDT) From: Stephan Szabo To: Rajesh Kumar Mallah Cc: PostgResql SQL Mailing List Subject: Re: abnormal size of the on-disk file. In-Reply-To: <3CC969AF.418C544B@trade-india.com> Message-ID: <20020429094521.G58196-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/362 X-Sequence-Number: 7626 On Fri, 26 Apr 2002, Rajesh Kumar Mallah wrote: > Hi There, > > I have a small table companies (< 300 rows) and its on-disk size shows > abnormal If you've been making modifications to the table rows and haven't been vacuuming you're going to have all the dead rows in the table as well as live ones. On 7.2 you'd need a vacuum full to clear the space at this point (you can use normal vacuum more frequently during normal operation to avoid needing the full). > does unvaccuming makes tables x2000 times largers??