| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 64-bit XIDs again |
| Date: | 2015-07-30 14:14:14 |
| Message-ID: | CANP8+jLivmgR7x8KVPp6F0NKrcFworOuKk0zKiu9z0T3HaKioQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 30 July 2015 at 14:26, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
wrote:
> Any thoughts? Do you think 64-bit XIDs worth it?
>
The problem of freezing is painful, but not impossible, which is why we
have held out so long.
The problem of very long lived snapshots is coming closer at the same speed
as freezing; there is no solution to that without 64-bit xids throughout
whole infrastructure, or CSNs.
The opportunity for us to have SQL Standard historical databases becomes
possible with 64-bit xids, or CSNs. That is a high value goal.
I personally now think we should thoroughly investigate 64-bit xids. I
don't see this as mere debate, I see this as something that we can make a
patch for and scientifically analyze the pros and cons through measurement.
--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2015-07-30 14:24:51 | Re: 64-bit XIDs again |
| Previous Message | Petr Jelinek | 2015-07-30 13:58:44 | Re: creating extension including dependencies |