> 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.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Andrew McMillan||Date: 2004-04-25 07:13:35|
|Subject: Re: Wierd context-switching issue on Xeon patch for 7.4.1|
|Previous:||From: Manfred Koizar||Date: 2004-04-25 00:28:37|
|Subject: Re: Why will vacuum not end?|