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