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 17:17:00 -0700
Message-ID: <dcc563d10902271617r262bcc6fmdd5a4e25f1606f9@mail.gmail.com> (raw)
In-Reply-To: <93739F94E0F3BA43AD72423E2482341AE064C0@sw-rz010.gsf.de>
References: <93739F94E0F3BA43AD72423E2482341AE064B7@sw-rz010.gsf.de>
<dcc563d10902270203t19f5a541iac7d69a2bd87cd0c@mail.gmail.com>
<93739F94E0F3BA43AD72423E2482341AE064C0@sw-rz010.gsf.de>
On Fri, Feb 27, 2009 at 4:42 AM, Lentes, Bernd
<bernd.lentes@helmholtz-muenchen.de> wrote:
>
>
> Scott Marlowe wrote:
>> -----Ursprüngliche Nachricht-----
>> Von: Scott Marlowe [mailto:scott.marlowe@gmail.com]
>> Gesendet: Freitag, 27. Februar 2009 11:04
>> 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.
>> > I red the documentation and made a vaccum on that database.
>> > In the documentation i also found the hint to look in the database
>> > with "SELECT datname, age(datfrozenxid) FROM pg_database;",
>> which i did.
>> > I did the command several times in a few seconds, and this
>> number is
>> > growing very quickly, although i'm not expecting
>> transactions in the database.
>>
>> Please note that nearly EVERYTHING that happens in postgres
>> is a transaction. if you type a single command, boom, it's a
>> transaction.
>> You actually get fewer transaction events if you enclose a
>> bunch of stuff in begin; commit; pairs than if you run single
>> commands.
>>
> Scott, why does the number increase ?
> If it says how many transactions are still possible, the number should decrease, not increase.
What I wrote was about the number you saw from the log entries. That
tells you how many transactions you have left before wraparound would
happen.
Read up on what the age() stuff means here:
http://www.postgresql.org/docs/8.3/static/routine-vacuuming.html
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: <dcc563d10902271617r262bcc6fmdd5a4e25f1606f9@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