Re: Vacuum - Mailing list pgsql-admin

From Rainer Mager
Subject Re: Vacuum
Date
Msg-id NEBBJBCAFMMNIHGDLFKGEEALFEAA.rmager@vgkk.com
Whole thread Raw
In response to Re: Vacuum  ("Summer S. Wilson" <collectonian@eclectic-world.com>)
List pgsql-admin
Hi all,

    I haven't been following this thread that carefully but when yesterday we
also had vacuuming problems I decided I should. Reading this message shows
that Summer's problem seems to be different than ours although they could be
connected.

    Yesterday our application stopped responding. After a little investigation
we found that 1 process on the db box was using 100% CPU. Via the ps command
we could see that there were 2 processes running continuously, a 'vacuum'
and a 'query'. Unfortunately I failed to note which was using 100% CPU.
    At the time of discovery the run-a-way process had used almost 1 hour CPU
time. Since the app wasn't responding I'm assuming one or more other
processes were blocked. I can only guess that the vacuum process was the
long one because under typical usage no queries in the application run for
more than a few seconds.

    I have since restarted the db with debug output turned on in order to track
down the queries. Any other ideas or suggestions? BTW, we're running with PG
7.1.3.


Thanks,

--Rainer


> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Summer S. Wilson
> Sent: Tuesday, October 09, 2001 10:20 PM
> To: pgsql-admin@postgresql.org
> Cc: tgl@sss.pgh.pa.us
> Subject: Re: [ADMIN] Vacuum
>
>
> Hi Tom,
>
> It does not appear to be consuming any CPU time, its just sitting there.
> I'm not sure what would be connected to it because we have nothing live
> right now, and none of the pages related to that table have been designed
> yet.  Is there a safe way to end the vacuum?
>
>
> Summer S. Wilson         ICQ 26835530
> Programmer/Analyst I, EIT TCE
> Webmaster, An Eclectic World http://eclectic-world.com


pgsql-admin by date:

Previous
From: "Chris Ruprecht"
Date:
Subject: Re: [REPOST] Remote database questions (NFS shared access, RServ)
Next
From: Steve Frampton
Date:
Subject: Database access error after upgrade 7.1.2 -> 7.1.3