Re: a "huge" table with small rows and culumns

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
To: Feng Xue <feng(at)axe(dot)net(dot)au>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: a "huge" table with small rows and culumns
Date: 2000-12-19 11:31:58
Message-ID: Pine.LNX.4.30.0012190630410.17179-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 19 Dec 2000, Feng Xue wrote:

> after I use VACUUM command to clean up the database, the table size
> shrinked from 25M to 0.5M, which is a BIG IMPROVEMENT!

If this is a production database that is being used by a lot of people,
you should run the vacuum on a regular basis, like maybe overnight as a
cron job.

-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
History is curious stuff
You'd think by now we had enough
Yet the fact remains I fear
They make more of it every year.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis Perchine 2000-12-19 11:35:17 Re: a "huge" table with small rows and culumns
Previous Message Trurl McByte 2000-12-19 10:33:11 Re: Simple mail() function for postgresql