Re: Help me recovering data - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: Help me recovering data
Date
Msg-id cv0tlg$2gj7$1@news.hub.org
Whole thread Raw
In response to Re: Help me recovering data  (Greg Stark <gsstark@mit.edu>)
Responses Re: Help me recovering data  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
> 
> 
>>Christopher Kings-Lynne wrote:
>>
>>
>>>I wonder if I should point out that we just had 3 people suffering XID
>>>wraparound failure in 2 days in the IRC channel...
>>
>>I have had half a dozen new customers in the last six months that have
>>had the same problem. Nothing like the phone call:
> 
> 
> How are so many people doing so many transactions so soon after installing?
> 
> To hit wraparound you have to do a billion transactions? ("With a `B'") That
> takes real work. If you did 1,000 txn/minute for every minute of every day it
> would still take a couple years to get there.

We do ~4000 txn/minute so in 6 month you are screewd up...



Regards
Gaetano Mendola




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange RETURN NEXT behaviour in Postgres 8.0
Next
From: Gaetano Mendola
Date:
Subject: Re: Help me recovering data