How many database-wide vacuums did you run during these 9 months? I'm
smelling transaction Id wraparound in pg_class or some other system
catalog.
This has been known to happen. Please see the archives.
"database wide" vacuums have been very very seldom; I fear the only one was at initial db bulk load. at the moment I am on a way to upgrade to 8.1, with autovacuum enabled ... so in the long run THAT possible reason should vanish.
And I understand correctly that your suspicion is: file gets killed because of transaction id wraparound in system table?
I will scan teh archives (as soon as postgresql.org provices access to them again :)
Harald
--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
