Manfred is indicating the reason it is taking so long is due to the number of dead tuples in my index and the vacuum_mem setting. The last delete that I did before starting a vacuum had 219,177,133 deletions. Dan. >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? VACUUM ANALYZE >-- What's your vacuum_mem setting? set vacuum_mem = '196608' #fsync = true # turns forced synchronization on or off #wal_sync_method = fsync >-- What are checkpoint and wal settings? wal_buffers = 64 checkpoint_segments = 30 checkpoint_timeout = 300 >> 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? I am not sure what the checkpoint_buffers are, we are running 7.4.0? >-- >Josh Berkus >Aglio Database Solutions >San Francisco ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match