From: Scott Marlowe <scott.marlowe@gmail.com>
To: Lentes, Bernd <bernd.lentes@helmholtz-muenchen.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Question to transaction ID wraparound
Date: Fri, 27 Feb 2009 03:02:23 -0700
Message-ID: <dcc563d10902270202q4511161dqf79785b2ee982d3a@mail.gmail.com> (raw)
In-Reply-To: <93739F94E0F3BA43AD72423E2482341AE064BD@sw-rz010.gsf.de>
References: <93739F94E0F3BA43AD72423E2482341AE064B7@sw-rz010.gsf.de>
<dcc563d10902260918r48599fc3jae97e121e333001c@mail.gmail.com>
<93739F94E0F3BA43AD72423E2482341AE064BD@sw-rz010.gsf.de>
On Fri, Feb 27, 2009 at 2:49 AM, Lentes, Bernd
<bernd.lentes@helmholtz-muenchen.de> wrote:
>
>
>
>
> Scott Marlowe wrote:
>> -----Ursprüngliche Nachricht-----
>> Von: Scott Marlowe [mailto:scott.marlowe@gmail.com]
>> Gesendet: Donnerstag, 26. Februar 2009 18:18
>> An: Lentes, Bernd
>> Cc: pgsql-admin@postgresql.org
>> Betreff: Re: [ADMIN] Question to transaction ID wraparound
>>
>> On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd
>> <bernd.lentes@helmholtz-muenchen.de> wrote:
>> > Hello ML,
>> >
>> > I'm very new to Postgres.
>> > In the log, i got messages concerning transaction ID wraparound.
>>
>> What exact message did you get?
>>
> The message is in german:
> Grenze für Transaktionsnummernüberlauf ist 1133954883, begrenzt durch Datenbank "genetrap"
> I try to translate:
> transaction ID wrap limit is 113..., limited by database "genetrap"
That's more an information message than something to get worried
about. It means that you can perform 1.13Billion transactions before
things have to get vacuumed to prevent wrap around. If it says 1M or
something, then start worrying. and the db will emit warnings and
such at that point.
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, bernd.lentes@helmholtz-muenchen.de
Subject: Re: Question to transaction ID wraparound
In-Reply-To: <dcc563d10902270202q4511161dqf79785b2ee982d3a@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