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

From: "Esa Pikkarainen" <epikkara(at)ktk(dot)oulu(dot)fi>
To: Denis Perchine <dyp(at)perchine(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: a "huge" table with small rows and culumns
Date: 2000-12-19 12:07:24
Message-ID: 319EA1012F9@ktk.oulu.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Denis Perchine wrote (19 Dec 00,):
> On Tuesday 19 December 2000 17:31, you 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. :-(((

Hey, I thought this is a standard method???!!! What do you suggest
instead?

Esa Pikkarainen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brett W. McCoy 2000-12-19 12:27:16 Re: a "huge" table with small rows and culumns
Previous Message Denis Perchine 2000-12-19 11:35:17 Re: a "huge" table with small rows and culumns