Skip site navigation (1) Skip section navigation (2)

Re: strange disappearence of postgres file

From: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>
To: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>, Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: strange disappearence of postgres file
Date: 2005-11-23 13:11:36
Message-ID: 7be3f35d0511230511w3fc490a3k@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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├če 202b
70197 Stuttgart
0173/9409607

In response to

Responses

pgsql-bugs by date

Next:From: Tatsuo IshiiDate: 2005-11-23 13:24:00
Subject: Re: [PATCHES] Patch to allow contrib/pgbench files to have blank
Previous:From: Alvaro HerreraDate: 2005-11-23 12:15:16
Subject: Re: strange disappearence of postgres file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group