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

From Brett W. McCoy
Subject Re: a "huge" table with small rows and culumns
Date
Msg-id Pine.LNX.4.30.0012190726530.17179-100000@chapelperilous.net
Whole thread Raw
In response to Re: a "huge" table with small rows and culumns  (Denis Perchine <dyp@perchine.com>)
List pgsql-general
On Tue, 19 Dec 2000, Denis Perchine wrote:

> > 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. :-(((

What do you suggest instead?

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Bahdges?  We don't need no stinkin' bahdges!
        -- "The Treasure of Sierra Madre"


pgsql-general by date:

Previous
From: "Esa Pikkarainen"
Date:
Subject: Re: a "huge" table with small rows and culumns
Next
From: Denis Perchine
Date:
Subject: Re: a "huge" table with small rows and culumns