Alvaro,
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=DFe 202b
70197 Stuttgart
0173/9409607