Postgres Pro
Downloads
Home   >   mailing lists

Re: a "huge" table with small rows and culumns - Mailing list pgsql-general

From Denis Perchine
Subject Re: a "huge" table with small rows and culumns
Date
Msg-id 00121917345403.08280@dyp.perchine.com
Whole thread Raw
In response to Re: a "huge" table with small rows and culumns  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Responses Re: a "huge" table with small rows and culumns  ("Esa Pikkarainen" <epikkara@ktk.oulu.fi>)
Re: a "huge" table with small rows and culumns  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-general
Tree view 
On Tuesday 19 December 2000 17:31, you wrote:
> 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.

That's really bad idea if you have 7.0.x. There are deadlocks possible. :-(((

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: a "huge" table with small rows and culumns
Next
From: "Esa Pikkarainen"
Date:
Subject: Re: a "huge" table with small rows and culumns