-----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.korot...@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----- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
