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

Re: Why will vacuum not end?

From: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>
To: 'Josh Berkus' <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why will vacuum not end?
Date: 2004-04-24 14:45:40
Message-ID: F2D63B916C88C14D9B59F93C2A5DD33F0B924F@cisxa.cmc.int.ec.gc.ca (view raw or flat)
Thread:
Lists: pgsql-performance
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?


-----Original Message-----
From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
Sent: Friday, April 23, 2004 2:48 PM
To: Shea,Dan [CIS]; 'Christopher Kings-Lynne'
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Why will vacuum not end?


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

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2004-04-24 15:35:21
Subject: Re: Why will vacuum not end?
Previous:From: Tom LaneDate: 2004-04-24 02:58:24
Subject: Re: Help with performance problems

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