From: Scott Marlowe <scott.marlowe@gmail.com>
To: alex <alex.pgsql@kerkhove.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgres 'forgets' table definitions
Date: Tue, 10 Jun 2008 09:52:29 -0600
Message-ID: <dcc563d10806100852r71e6d58fl6da36fe856826cbb@mail.gmail.com> (raw)
In-Reply-To: <484E88AB.6020505@kerkhove.net>
References: <484E61A0.5030706@kerkhove.net>
<484E88AB.6020505@kerkhove.net>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, alex.pgsql@kerkhove.net
Subject: Re: postgres 'forgets' table definitions
In-Reply-To: <dcc563d10806100852r71e6d58fl6da36fe856826cbb@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox