Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n5Sc3-0001rs-Ma for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Jan 2022 13:15:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n5Sc2-0000J1-JL for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Jan 2022 13:15:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n5Sc2-0000Is-6U for pgsql-hackers@lists.postgresql.org; Thu, 06 Jan 2022 13:15:26 +0000 Received: from smtp-fw-33001.amazon.com ([207.171.190.10]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n5Sbz-0003H0-TQ for pgsql-hackers@postgresql.org; Thu, 06 Jan 2022 13:15:25 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1641474924; x=1673010924; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=g7oJktASuglyQcsUjDThGSf155GqTUBa7MC38939atE=; b=eh2eI3oTY+cllZhRsFZ4JYW68ul0OSsbCvjHrkH0UzAfZrSNdwQDSuPM +9nV+iUJxvh1fSvtduBbZd0y4R2XFtG34kOckRPF4yccXQF/JkNIKfjFx ua2Yyy7gxz+8nArJuLDKk2xnSwg3j2Dppf7XvquPpvGmibGnHFavCPYS3 M=; X-IronPort-AV: E=Sophos;i="5.88,267,1635206400"; d="scan'208";a="168382985" Received: from iad12-co-svc-p1-lb1-vlan2.amazon.com (HELO email-inbound-relay-pdx-2c-9ec26c6c.us-west-2.amazon.com) ([10.43.8.2]) by smtp-border-fw-33001.sea14.amazon.com with ESMTP; 06 Jan 2022 13:15:23 +0000 Received: from EX13MTAUEE001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-pdx-2c-9ec26c6c.us-west-2.amazon.com (Postfix) with ESMTPS id 745A442F59; Thu, 6 Jan 2022 13:15:21 +0000 (UTC) Received: from EX13D09UEE001.ant.amazon.com (10.43.62.205) by EX13MTAUEE001.ant.amazon.com (10.43.62.226) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Thu, 6 Jan 2022 13:15:20 +0000 Received: from EX13D09UEE001.ant.amazon.com (10.43.62.205) by EX13D09UEE001.ant.amazon.com (10.43.62.205) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Thu, 6 Jan 2022 13:15:19 +0000 Received: from EX13D09UEE001.ant.amazon.com ([10.43.62.205]) by EX13D09UEE001.ant.amazon.com ([10.43.62.205]) with mapi id 15.00.1497.026; Thu, 6 Jan 2022 13:15:19 +0000 From: "Finnerty, Jim" To: Maxim Orlov CC: pgsql-hackers Subject: Re: Add 64-bit XIDs into PostgreSQL 15 Thread-Topic: Add 64-bit XIDs into PostgreSQL 15 Thread-Index: AQHYAv901uDcMyYFokqFyF+6lHLhdA== Date: Thu, 6 Jan 2022 13:15:19 +0000 Message-ID: <6960BD21-E46F-4682-9A59-17716B346019@amazon.com> References: <20220104193220.GL15820@tamriel.snowman.net> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.62.229] Content-Type: text/plain; charset="utf-8" Content-ID: <74B1C5D3F5C4D749830ED96D1885C52D@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk KE1heGltKSBSZTogLS0gSWYgYWZ0ZXIgdXBncmFkZSBwYWdlIGhhcyBubyBmcmVlIHNwYWNlIGZv ciBzcGVjaWFsIGRhdGEsIHR1cGxlcyBhcmUNCiAgICAgICBjb252ZXJ0ZWQgdG8gImRvdWJsZSB4 bWF4IiBmb3JtYXQ6IHhtaW4gYmVjYW1lIHZpcnR1YWwNCiAgICAgICBGcm96ZW5UcmFuc2FjdGlv bklkLCB4bWF4IG9jY3VwaWVzIHRoZSB3aG9sZSA2NGJpdC4NCiAgICAgICBQYWdlIGNvbnZlcnRl ZCB0byBuZXcgZm9ybWF0IHdoZW4gdmFjdXVtIGZyZWVzIGVub3VnaCBzcGFjZS4NCg0KQSBiZXR0 ZXIgd2F5IHdvdWxkIGJlIHRvIHByZXBhcmUgdGhlIGRhdGFiYXNlIGZvciBjb252ZXJzaW9uIHRv IHRoZSA2NC1iaXQgWElEIGZvcm1hdCBiZWZvcmUgdGhlIHVwZ3JhZGUgc28gdGhhdCBpdCBlbnN1 cmVzIHRoYXQgZXZlcnkgcGFnZSBoYXMgZW5vdWdoIHJvb20gZm9yIHRoZSB0d28gbmV3IGVwb2No cyAoRSBiaXRzKS4NCg0KMS4gRW5mb3JjZSB0aGUgcnVsZSB0aGF0IG5vIElOU0VSVCBvciBVUERB VEUgdG8gYW4gZXhpc3RpbmcgcGFnZSB3aWxsIGxlYXZlIGxlc3MgdGhhbiBFIGJpdHMgb2YgZnJl ZSBzcGFjZSBvbiBhIGhlYXAgcGFnZQ0KDQoyLiBSdW4gYW4gb25saW5lIGFuZCByZXN0YXJ0YWJs ZSB0YXNrLCBhbmFsb2dvdXMgdG8gcGdfcmVwYWNrLCB0aGF0IHJld3JpdGVzIGFuZCBzcGxpdHMg YW55IHBhZ2UgdGhhdCBoYXMgbGVzcyB0aGFuIEUgYml0cyBvZiBmcmVlIHNwYWNlLiBUaGlzIG5l ZWRzIHRvIGJlIHJ1biBvbiBhbGwgbm9uLXRlbXAgdGFibGVzIGluIGFsbCBzY2hlbWFzIGluIGFs bCBkYXRhYmFzZXMuICBEREwgb3BlcmF0aW9ucyBhcmUgbm90IGFsbG93ZWQgb24gYSB0YXJnZXQg dGFibGUgd2hpbGUgdGhpcyBvcGVyYXRpb24gcnVucywgd2hpY2ggaXMgZW5mb3JjZWQgYnkgdGFr aW5nIGFuIEFDQ0VTUyBTSEFSRSBsb2NrIG9uIGVhY2ggdGFibGUgd2hpbGUgdGhlIHByb2Nlc3Mg aXMgcnVubmluZy4gVG8gbWl0aWdhdGUgdGhlIGVmZmVjdHMgb2YgdGhpcyByZXN0cmljdGlvbiwg dGhlIHJlc3RhcnRhYmxlIHRhc2sgY2FuIGJlIHJlc3RyaWN0ZWQgdG8gcnVuIG9ubHkgaW4gY2Vy dGFpbiBob3Vycy4gIFRoaXMgY291bGQgYmUgaW1wbGVtZW50ZWQgYXMgYSBiYWNrZ3JvdW5kIG1h aW50ZW5hbmNlIHRhc2sgdGhhdCBydW5zIGZvciBYIGhvdXJzIGFzIG9mIGEgY2VydGFpbiB0aW1l IG9mIGRheSBhbmQgdGhlbiBraWNrcyBpdHNlbGYgb2ZmIGFnYWluIGluIDI0LVggaG91cnMsIGxv Z2dpbmcgaXRzIHByb2dyZXNzLg0KDQpXaGVuIHRoaXMgdGFzayBjb21wbGV0ZXMsIHRoZSBkYXRh YmFzZSBpcyByZWFkeSBmb3IgdXBncmFkZSB0byA2NC1iaXQgWElEcywgYW5kIHRoZXJlIGlzIG5v IHBvc3NpYmlsaXR5IHRoYXQgYW55IHBhZ2UgaGFzIGluc3VmZmljaWVudCBmcmVlIHNwYWNlIGZv ciB0aGUgc3BlY2lhbCBkYXRhLg0KDQpXb3VsZCB5b3UgYWdyZWUgdGhhdCB0aGlzIGFwcHJvYWNo IHdvdWxkIGNvbXBsZXRlbHkgZWxpbWluYXRlIHRoZSBuZWVkIGZvciBhICJkb3VibGUgeG1heCIg cmVwcmVzZW50YXRpb24/IA0KDQogICAgICAgIC9KaW0NCg0KDQo=