Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f2UDGUK38718 for ; Fri, 30 Mar 2001 08:16:30 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from vrtx.co.uk (vortex1.vrtx.net [195.224.63.4]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2SF6wU98184 for ; Wed, 28 Mar 2001 10:06:59 -0500 (EST) (envelope-from james@fsck.co.uk) Received: from localhost (james@localhost) by vrtx.co.uk (8.9.3/8.8.8) with ESMTP id QAA11180; Wed, 28 Mar 2001 16:06:14 +0100 Date: Wed, 28 Mar 2001 16:06:13 +0100 (BST) From: A James Lewis X-X-Sender: To: "Poul L. Christiansen" cc: Graham Vickrage , Postgres SQL Subject: Re: Killing Postmaster In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200103/635 X-Sequence-Number: 2306 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!