From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Rajesh Kumar Mallah <mallah@trade-india.com>
Cc: PostgResql SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: abnormal size of the on-disk file.
Date: Mon, 29 Apr 2002 09:46:59 -0700 (PDT)
Message-ID: <20020429094521.G58196-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <3CC969AF.418C544B@trade-india.com>
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??
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, mallah@trade-india.com
Subject: Re: abnormal size of the on-disk file.
In-Reply-To: <20020429094521.G58196-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox