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@varlena.com