pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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??




view thread (2+ messages)

Message-ID: <20020429094521.G58196-100000@megazone23.bigpanda.com>
Permalink:  ../20020429094521.G58196-100000@megazone23.bigpanda.com/
Also on:    postgresql.org/message-id/20020429094521.G58196-100000@megazone23.bigpanda.com

 · 

reply

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