| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | ARTEAGA Jose <Jose(dot)Arteaga(at)alcatel-lucent(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Limitations on 7.0.3? |
| Date: | 2007-06-08 16:38:33 |
| Message-ID: | 20070608163833.GB9818@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jun 07, 2007 at 02:32:09PM -0500, ARTEAGA Jose wrote:
> I've looked at the pg_index table and we are currently at 15Mill
> entries, which should be OK. After 2-3 days runtime I just get a
> disconnect error from backend while doing an insert. After I restore the
> DB and insert the same entries it runs fine. Following is the error I
> get:
Note: Version 7.0 *will* eat your data eventually. It has no protection
against XID wraparound, you'll just start noticing data disappearing.
From the documentation:
Prior to PostgreSQL 7.2, the only defense against XID wraparound was to
re-initdb at least every 4 billion transactions.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-06-08 16:45:07 | Re: Limitations on 7.0.3? |
| Previous Message | Ed L. | 2007-06-08 16:34:24 | Re: query log corrupted-looking entries |