Re: abnormal size of the on-disk file. - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: abnormal size of the on-disk file.
Date
Msg-id 20020429094521.G58196-100000@megazone23.bigpanda.com
Whole thread Raw
In response to abnormal size of the on-disk file.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-sql
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??



pgsql-sql by date:

Previous
From: Joseph Barillari
Date:
Subject: Re: Casting dates
Next
From: "Frank Morton"
Date:
Subject: convert from sybase to postgresql