Re: Why will vacuum not end? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Why will vacuum not end?
Date
Msg-id 200404231147.58279.josh@agliodbs.com
Whole thread Raw
In response to Re: Why will vacuum not end?  ("Shea,Dan [CIS]" <Dan.Shea@ec.gc.ca>)
List pgsql-performance
Guys,

> Well, inserts create some locks - perhaps that's the problem...
>
> Otherwise, check the pg_locks view to see if you can figure it out.

FWIW, I've had this happen a couple of times, too.   Unfortunately, it's
happend in the middle of the day so that I had to cancel the processes and
get the system back to normal in too much of a hurry to consider documenting
it.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: "Shea,Dan [CIS]"
Date:
Subject: Re: Why will vacuum not end?
Next
From: Ron St-Pierre
Date:
Subject: Re: Help with performance problems