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>,'Manfred Koizar' <mkoi-pg(at)aon(dot)at>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why will vacuum not end?
Date: 2004-04-25 01:49:07
Message-ID: 200404241849.07896.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Dan,

> There were defintely 219,177,133 deletions.
> The deletions are most likely from the beginning, it was based on the
> reception_time of the data.

You need to run VACUUM more often, I think.    Vacuuming out 219 million dead 
tuples is going to take a long time no matter how you look at it.   If you 
vacuum more often, presumably there will be less for Vacuum to do each time.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: Andrew McMillanDate: 2004-04-25 07:13:35
Subject: Re: Wierd context-switching issue on Xeon patch for 7.4.1
Previous:From: Manfred KoizarDate: 2004-04-25 00:28:37
Subject: Re: Why will vacuum not end?

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