Thread: Killing Postmaster
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
Attachment
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 there any error message? Poul L. Christiansen
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 output of a vacuum verbose, but I'm sure other people on this list do :-) Poul L. Christiansen On Wed, 28 Mar 2001, A James Lewis wrote: > > 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 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 there any error message? > > > > Poul L. Christiansen > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > A. James Lewis (james@fsck.co.uk) > If your OS needs a virus detector... RUN!!! > ...Out and get Linux! >
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 try in verbose mode! or perhaps kill it and upgrade to 7! On Wed, 28 Mar 2001, Poul L. Christiansen wrote: > 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 output of a vacuum verbose, but I'm sure other > people on this list do :-) > > Poul L. Christiansen > > On Wed, 28 Mar 2001, A James Lewis wrote: > > > > > 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 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 there any error message? > > > > > > Poul L. Christiansen > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 4: Don't 'kill -9' the postmaster > > > > > > > A. James Lewis (james@fsck.co.uk) > > If your OS needs a virus detector... RUN!!! > > ...Out and get Linux! > > > A. James Lewis (james@fsck.co.uk) If your OS needs a virus detector... RUN!!! ...Out and get Linux!
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 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 there any error message? > > Poul L. Christiansen > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > A. James Lewis (james@fsck.co.uk) If your OS needs a virus detector... RUN!!! ...Out and get Linux!