| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Frank Foerster <frankwordsten(at)googlemail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: 64 bit XID / Wraparound / Streaming Replication |
| Date: | 2012-05-07 13:39:44 |
| Message-ID: | 24303.1336397984@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Frank Foerster <frankwordsten(at)googlemail(dot)com> writes:
> My question is: do other users experience the same problem and what is
> their preferred way of dealing with it ? Also, i am aware of a discussion
> a few years ago that dealt with the usage of 64bit XIDs, but led nowhere.
> Are there any more recent plans or discussions concerning 64bit XIDs ?
I don't believe anybody is actively thinking about 64-bit XIDs at
present; the additional row storage overhead is unpleasant to
contemplate. I'd suggest looking at whether you couldn't reduce your
rate of consumption of XIDs, for instance by merging updates into a
single transaction when possible.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2012-05-07 14:11:23 | Re: execute stored function from ms visual foxpro |
| Previous Message | Frank Foerster | 2012-05-07 10:09:06 | 64 bit XID / Wraparound / Streaming Replication |