| From: | "Mark Woodward" <pgsql(at)mohawksoft(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | How to avoid transaction ID wrap |
| Date: | 2006-06-06 12:42:50 |
| Message-ID: | 18119.24.91.171.78.1149597770.squirrel@mail.mohawksoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
OK, here's my problem, I have a nature study where we have about 10 video
cameras taking 15 frames per second.
For each frame we make a few transactions on a PostgreSQL database.
We want to keep about a years worth of data at any specific time.
We have triggers that fire is something interesting is found on insert.
We want this thing to run for a log time.
>From the numbers, you can see the PostgreSQL database is VERY loaded.
Running VACUUM may not always be possible without losing data.
The numbers I have amount to 466,560,000 transactions per month, lasting a
maximum of about 9 months until XID wrap.
I am thinking about a few work arounds, BEGIN/COMMIT to reduce the number
of transactions, COPY, etc. so I'm not dead in the water, but I would be
interested in any observations yo may have.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2006-06-06 12:45:13 | Re: How to avoid transaction ID wrap |
| Previous Message | Hannu Krosing | 2006-06-06 12:30:12 | Re: [PERFORM] psql -A (unaligned format) eats too much |