Re: postgres 'forgets' table definitions - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: postgres 'forgets' table definitions
Date
Msg-id dcc563d10806100852r71e6d58fl6da36fe856826cbb@mail.gmail.com
Whole thread Raw
In response to Re: postgres 'forgets' table definitions  (alex <alex.pgsql@kerkhove.net>)
List pgsql-admin
On Tue, Jun 10, 2008 at 7:59 AM, alex <alex.pgsql@kerkhove.net> wrote:
> Problem solved!
>
> Even without vacuuming, I don't think postgres should ever behave like this, but I'm glad my problem is solved now.
>
> (perhaps this issue is fixed in newer releases, if not someone might want to look in to this pg_* tables/vacuum
issue)

As Jaime mentioned already, vacuuming is required.  However, in
addition to his point about various improvements, newer version will
begin throwing errors as they get closer to txid wraparound, and will
eventually shut down and refuse to run in multi-user mode once it
reaches a certain point.

So, yes, things have improved.

pgsql-admin by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: postgres 'forgets' table definitions
Next
From: "Hays Steve - sthays"
Date:
Subject: Cannot Drop Schema