Josh, how long should a vacuum take on a 87 GB table with a 39 GB index?
I do not think that the verbose option of vacuum is verbose enough.
The vacuum keeps redoing the index, but there is no indication as to why it
is doing this.
I see alot of activity with transaction logs being recycled (15 to 30 every
3 to 20 minutes).
Is the vacuum causing this?
From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
Sent: Friday, April 23, 2004 2:48 PM
To: Shea,Dan [CIS]; 'Christopher Kings-Lynne'
Subject: Re: [PERFORM] Why will vacuum not end?
> 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
Aglio Database Solutions
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2004-04-24 15:35:21|
|Subject: Re: Why will vacuum not end?|
|Previous:||From: Tom Lane||Date: 2004-04-24 02:58:24|
|Subject: Re: Help with performance problems |