Running version 8.1.2, 1-2G RAM. Configuration set up to use available RAM. Running autovacuum. I have a table with 8500000 rows. The table gets only inserts (constantly). Once a day a range of the rows is deleted and an explicit vacuum analyze of the table is done. The table has 4 indexes. Much later in the day, a vacuum analyze of the db showed that all of the indexes for that table required significant vacuuming, although the table did not. A bit later, further vacuuming showed more indexes required vacuuming and again the table did not. In what situation would these indexes require the further vacuuming? Due to the insert only activity on the table (and the db, mostly), I cannot understand why the indexes require further vacuuming. Ideas? --elein elein@xxxxxxxxxxx
