Re: Avoiding transaction ID wrap

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nickf(at)ontko(dot)com
Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Avoiding transaction ID wrap
Date: 2002-04-25 22:31:22
Message-ID: 8988.1019773882@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Nick Fankhauser" <nickf(at)ontko(dot)com> writes:
> Watching Michael's problem vicariously has me all worried about transaction
> ID wrap now.

> I'm on v7.1.3- will checking the size of $PGDATA/pg_log work for me as well?

> At what size should I begin to worry?

If you get to 1GB (4 billion transactions at 2 bits each) you are screwed.

Anyone who is over the 1-billion-xacts mark (250MB pg_log) probably
ought to be thinking about moving to 7.2 sooner, not later.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-04-25 22:34:43 Re: Avoiding transaction ID wrap
Previous Message Lamar Owen 2002-04-25 22:27:32 Re: RPMS