Dan,
> Josh, how long should a vacuum take on a 87 GB table with a 39 GB index?
Depends:
-- What's your disk support?
-- VACUUM, VACUUM ANALYZE, or VACUUM FULL?
-- What's your vacuum_mem setting?
-- What are checkpoint and wal settings?
> I see alot of activity with transaction logs being recycled (15 to 30 every
> 3 to 20 minutes).
> Is the vacuum causing this?
Probably, yes. How many checkpoint_buffers do you allow?
--
Josh Berkus
Aglio Database Solutions
San Francisco