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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> 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-2017 The PostgreSQL Global Development Group