I have a vacuum which has been running for about a week, is that too long?
On Wed, 28 Mar 2001, Poul L. Christiansen wrote:
> On Wed, 28 Mar 2001, Graham Vickrage wrote:
>
> > Hi All,
> >
> > What is the correct way of killing postgres 7.0 on redhat linux.
>
> "man pg_ctl".
>
> >
> > Is there a
It's not a machine I look at often, and I realiased that it's database had
never been vacuumed and had grown to about 2 gigs
It is a dual PII 450, with 384 megs and U2W disks... but I started the
vacuum about 10 days ago.. and when I checked it hadn't finished... I
guess I'll kill it and t
A week? That sounds much too long to me (assuming that you have
PostgresSQL funning on fairly good hardware).
There could be something wrong with at specific table. Try to vacuum a
table one at the time using "vacuum verbose MyTable", and report any error
you may find.
I don't understand the ou
On Wed, 28 Mar 2001, Graham Vickrage wrote:
> Hi All,
>
> What is the correct way of killing postgres 7.0 on redhat linux.
"man pg_ctl".
>
> Is there a reason why vacuum hangs on a DB with about 1.5 million rows?
Vacuum can take a long time with 1.5M records. How long have you
waited? Is the
Hi All,
What is the correct way of killing postgres 7.0 on redhat linux.
Is there a reason why vacuum hangs on a DB with about 1.5 million rows?
Cheers
Graham
winmail.dat
---(end of broadcast)---
TIP 6: Have you searched our list archives?
