The following bug has been logged online:
Bug reference: 4874
Logged by: Roman Galeev
Email address: ip@ncom-ufa.ru
PostgreSQL version: 8.1
Operating system: Debian Sarge
Description: vacuum doest work
Details:
I've constantly got messages like this:
2009-06-23 20:43:42 YEKST WARNING: database "testing" must be vacuumed
within 10532638 transactions
2009-06-23 20:43:42 YEKST ÐÐÐСÐÐÐÐÐ: To avoid a database shutdown,
execute a full-database VACUUM in "testing".
but issuing vacuum does not help.
I've issued vacuum, vacuum full, vacuum freeze several times.
The only change I see is decreasing number of transactions.