| From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Help me recovering data |
| Date: | 2005-02-17 01:56:54 |
| Message-ID: | cv0tlg$2gj7$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Greg Stark wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2005-02-17 01:58:53 | Re: Help me recovering data |
| Previous Message | Tom Lane | 2005-02-17 00:38:42 | Re: Strange RETURN NEXT behaviour in Postgres 8.0 |