Re: 64-bit XIDs again - Mailing list pgsql-hackers

From Joe Conway
Subject Re: 64-bit XIDs again
Date
Msg-id 55BA3573.10706@joeconway.com
Whole thread Raw
In response to Re: 64-bit XIDs again  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 07/30/2015 07:14 AM, Simon Riggs wrote:
> On 30 July 2015 at 14:26, Alexander Korotkov
> <a.korotkov@postgrespro.ru
> 
> 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.

+1

I've been thinking along similar lines to both of you for quite some
time now. I think at the least we should explore an initdb time option
- -- we can and should measure the pros and cons.


- -- 
Joe Conway
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iQIcBAEBAgAGBQJVujVzAAoJEDfy90M199hlphUP/j/+TEJO05h+aLD1TrddZ01f
Fq2ijyvQjfe3aBN/4DEKuVBPMsQ6ZWLWtYJ3/FpktlFUIoDdDWJY//8rb63KqUut
tiSMI4MNzIp/ImvyR1pMJpAmfF9zHsJOiC8Hjpj9J8ity1BXm5My0XYzf9cux/KN
Qr8e5RTiPNKZyCB7w5Ci9byYIQKwHS9UyoHhgXQhZTopYLqrN9G7KxjKHZjTYxAs
6uJowQqsoevlgi15L8Ojk+KuJuowEHhVthhZ0f147twrOu2PwvhPP0/tf3TCSzKW
I3TGC8ChQ67+h/x4lF2LMENvDwGZFh0fB4foeu0F3oR5YX4jG6pic/k7BJFPke3f
YPk8PnA4fn5PM2otgikExIM6NFm+1y4JEeVOcGaA0GungdbgcBuN4p8gLvO9zJRa
qsJp6U+FHK7m68jBVAlo0aVERikh29devypOSWhz474nvYsZIm9bfQ4te+DQECzw
m3a9KJWJUy7Bj8xkwLpMMXmm83bIbvNMj8oDlg9tMo//CEzSsXyNjGUPG0/U9jIs
YHZUYd24i8Wg4+BjdQ19ULJH22ROZa2JBq658t6n97vab7HS3ZWGPhao0piYW20i
/q8wmd52KE0e4gg4Jixc1p8kPvIItFeJliEPgbRC1+7vnZu0rkENxXpTuS/g1fn0
Ql/P9C7Nb97cux9EvlZv
=gX7d
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: 64-bit XIDs again
Next
From: Heikki Linnakangas
Date:
Subject: Re: LWLock deadlock and gdb advice