pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedKilling Postmaster
5+ messages / 3 participants
[nested] [flat]
* Killing Postmaster
@ 2001-03-28 13:27 Graham Vickrage <graham@digitalplanit.com>
0 siblings, 1 reply; 5+ messages in thread
From: Graham Vickrage @ 2001-03-28 13:27 UTC (permalink / raw)
To: pgsql-sql
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
Attachments:
winmail.dat (application/ms-tnef, 1.5K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Killing Postmaster
@ 2001-03-28 13:45 Poul L. Christiansen <poulc@cs.auc.dk>
parent: Graham Vickrage <graham@digitalplanit.com>
0 siblings, 1 reply; 5+ messages in thread
From: Poul L. Christiansen @ 2001-03-28 13:45 UTC (permalink / raw)
To: Graham Vickrage <graham@digitalplanit.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Killing Postmaster
@ 2001-03-28 14:23 A James Lewis <james@fsck.co.uk>
parent: Poul L. Christiansen <poulc@cs.auc.dk>
0 siblings, 1 reply; 5+ messages in thread
From: A James Lewis @ 2001-03-28 14:23 UTC (permalink / raw)
To: Poul L. Christiansen <poulc@cs.auc.dk>; +Cc: Graham Vickrage <graham@digitalplanit.com>; pgsql-sql
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!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Killing Postmaster
@ 2001-03-28 14:40 Poul L. Christiansen <poulc@cs.auc.dk>
parent: A James Lewis <james@fsck.co.uk>
0 siblings, 1 reply; 5+ messages in thread
From: Poul L. Christiansen @ 2001-03-28 14:40 UTC (permalink / raw)
To: A James Lewis <james@fsck.co.uk>; +Cc: Graham Vickrage <graham@digitalplanit.com>; pgsql-sql
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!
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Killing Postmaster
@ 2001-03-28 15:06 A James Lewis <james@fsck.co.uk>
parent: Poul L. Christiansen <poulc@cs.auc.dk>
0 siblings, 0 replies; 5+ messages in thread
From: A James Lewis @ 2001-03-28 15:06 UTC (permalink / raw)
To: Poul L. Christiansen <poulc@cs.auc.dk>; +Cc: Graham Vickrage <graham@digitalplanit.com>; pgsql-sql
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!
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-03-28 15:06 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-28 13:27 Killing Postmaster Graham Vickrage <graham@digitalplanit.com>
2001-03-28 13:45 ` Poul L. Christiansen <poulc@cs.auc.dk>
2001-03-28 14:23 ` A James Lewis <james@fsck.co.uk>
2001-03-28 14:40 ` Poul L. Christiansen <poulc@cs.auc.dk>
2001-03-28 15:06 ` A James Lewis <james@fsck.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox