Re: Question to transaction ID wraparound

On Fri, Feb 27, 2009 at 2:49 AM, Lentes, Bernd
<bernd(dot)lentes(at)helmholtz-muenchen(dot)de> wrote:
>
>
>
>
> Scott Marlowe wrote:
>> -----Ursprüngliche Nachricht-----
>> Von: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
>> Gesendet: Donnerstag, 26. Februar 2009 18:18
>> An: Lentes, Bernd
>> Cc: pgsql-admin(at)postgresql(dot)org
>> Betreff: Re: [ADMIN] Question to transaction ID wraparound
>>
>> On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd
>> <bernd(dot)lentes(at)helmholtz-muenchen(dot)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.