Skip site navigation (1) Skip section navigation (2)

Re: Why will vacuum not end?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>,'Christopher Kings-Lynne' <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why will vacuum not end?
Date: 2004-04-23 18:47:58
Message-ID: 200404231147.58279.josh@agliodbs.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Ron St-PierreDate: 2004-04-23 18:57:23
Subject: Re: Help with performance problems
Previous:From: Shea,Dan [CIS]Date: 2004-04-23 18:19:04
Subject: Re: Why will vacuum not end?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group