Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r18vz-009YFC-7v for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Nov 2023 17:35:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r18vx-00G44I-24 for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Nov 2023 17:35:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r18vw-00G446-LB for pgsql-hackers@lists.postgresql.org; Thu, 09 Nov 2023 17:35:12 +0000 Received: from smtp-fw-80007.amazon.com ([99.78.197.218]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r18vt-005ZN0-5x for pgsql-hackers@postgresql.org; Thu, 09 Nov 2023 17:35:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1699551309; x=1731087309; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=Qqy2l/zRDBT+74y8W94W9AMrPHlJrq4ccshKzyq7DvE=; b=NCF8SxwmMuC+ofxpzldgoADkSd5Ov0pgWFPWHrvDFDEjhXcphS5gcTd5 4jBUEL0iUasZUIJ+tRxxoxn4M0yKh+H0fAwkRqxNYLf94KIuOAu4Wqcmq NEx15nmT0FhWs0/p9MbMwl2d63Yguoh7/Ozu1fStW320UscuPFf/Rh/j3 8=; X-IronPort-AV: E=Sophos;i="6.03,289,1694736000"; d="scan'208";a="251846598" Subject: Re: pg_upgrade failing for 200+ million Large Objects Thread-Topic: pg_upgrade failing for 200+ million Large Objects Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-pdx-2c-m6i4x-dc7c3f8b.us-west-2.amazon.com) ([10.25.36.210]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 09 Nov 2023 17:35:04 +0000 Received: from smtpout.prod.us-east-1.prod.farcaster.email.amazon.dev (pdx2-ws-svc-p26-lb5-vlan2.pdx.amazon.com [10.39.38.66]) by email-inbound-relay-pdx-2c-m6i4x-dc7c3f8b.us-west-2.amazon.com (Postfix) with ESMTPS id 46287A072B; Thu, 9 Nov 2023 17:35:03 +0000 (UTC) Received: from EX19MTAEUC001.ant.amazon.com [10.0.10.100:23662] by smtpin.naws.eu-west-1.prod.farcaster.email.amazon.dev [10.0.45.210:2525] with esmtp (Farcaster) id 3cdb19c3-c017-4ccb-998b-80d60f84b0f0; Thu, 9 Nov 2023 17:35:02 +0000 (UTC) X-Farcaster-Flow-ID: 3cdb19c3-c017-4ccb-998b-80d60f84b0f0 Received: from EX19D040EUC001.ant.amazon.com (10.252.61.226) by EX19MTAEUC001.ant.amazon.com (10.252.51.193) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.39; Thu, 9 Nov 2023 17:35:02 +0000 Received: from EX19D040EUC002.ant.amazon.com (10.252.61.192) by EX19D040EUC001.ant.amazon.com (10.252.61.226) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.39; Thu, 9 Nov 2023 17:35:01 +0000 Received: from EX19D040EUC002.ant.amazon.com ([fe80::f5ad:6b9e:9eb3:808f]) by EX19D040EUC002.ant.amazon.com ([fe80::f5ad:6b9e:9eb3:808f%4]) with mapi id 15.02.1118.039; Thu, 9 Nov 2023 17:35:01 +0000 From: "Kumar, Sachin" To: Jacob Champion , Nathan Bossart CC: Jan Wieck , Tom Lane , Bruce Momjian , Zhihong Yu , Andrew Dunstan , Magnus Hagander , Robins Tharakan , Peter Eisentraut , "pgsql-hackers@postgresql.org" Thread-Index: AQHZ/dSQ82fNvcIj80qBVj8+n9DrarByaniA Date: Thu, 9 Nov 2023 17:35:01 +0000 Message-ID: <0643CC11-223A-4039-AC34-94E127462796@amazon.com> References: <986904.1616525964@sss.pgh.pa.us> <6cccaa33-c263-b8a2-b064-985605d33d25@wi3ck.info> <988415.1616528159@sss.pgh.pa.us> <872315a8-99fc-da4e-463d-784cfb5a025d@wi3ck.info> <1010642.1616532950@sss.pgh.pa.us> <802b96e9-f5e1-015c-dfb9-8756974b11fc@wi3ck.info> <0263bf35-05d6-02a1-519b-b7895a918314@wi3ck.info> <20220825003227.GA1456581@nathanxps13> <663393ca-b2ff-26f0-2e2d-adc942aff4fd@timescale.com> <20220908231807.GA2242918@nathanxps13> In-Reply-To: Accept-Language: en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.82.15] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk DQoNCu+7vw0KDQpIaSBFdmVyeW9uZSAsIEkgd2FudCB0byBjb250aW51ZSB0aGlzIHRocmVhZCAs IEkgaGF2ZSByZWJhc2VkIHRoZSBwYXRjaCB0byBsYXRlc3QNCm1hc3RlciBhbmQgZml4ZWQgYW4g aXNzdWUgd2hlbiBwZ19yZXN0b3JlIHByaW50cyB0byBmaWxlLg0KDQpgDQrilbDilIAkIHBnX3Jl c3RvcmUgIGR1bXBfc21hbGwuY3VzdG9tICAtLXJlc3RvcmUtYmxvYi1iYXRjaC1zaXplPTIgLS1m aWxlPWENCi0tDQotLSBFbmQgQkxPQiByZXN0b3JlIGJhdGNoDQotLQ0KQ09NTUlUOw0KYA0KDQo+ IE9uIDA5LzExLzIwMjMsIDE3OjA1LCAiSmFjb2IgQ2hhbXBpb24iIDxqY2hhbXBpb25AdGltZXNj YWxlLmNvbSA8bWFpbHRvOmpjaGFtcGlvbkB0aW1lc2NhbGUuY29tPj4gd3JvdGU6DQo+IFRvIGNs YXJpZnksIEkgYWdyZWUgdGhhdCBwZ19kdW1wIHNob3VsZCBjb250YWluIHRoZSBjb3JlIGZpeC4g V2hhdCBJJ20NCj4gcXVlc3Rpb25pbmcgaXMgdGhlIGFkZGl0aW9uIG9mIC0tZHVtcC1vcHRpb25z IHRvIG1ha2UgdXNlIG9mIHRoYXQgZml4DQo+IGZyb20gcGdfdXBncmFkZSwgc2luY2UgaXQgYWxz byBsZXRzIHRoZSB1c2VyIGRvICJleGNpdGluZyIgbmV3IHRoaW5ncw0KPiBsaWtlIC0tZXhjbHVk ZS1zY2hlbWEgYW5kIC0taW5jbHVkZS1mb3JlaWduLWRhdGEgYW5kIHNvIG9uLiBJIGRvbid0DQo+ IHRoaW5rIHdlIHNob3VsZCBsZXQgdGhlbSBkbyB0aGF0IHdpdGhvdXQgYSBnb29kIHJlYXNvbi4N Cg0KRWFybGllciBpZGVhIHdhcyB0byBub3QgZXhwb3NlIHRoZXNlIG9wdGlvbnMgdG8gdXNlcnMg YW5kIHVzZSBbMV0NCiAgIC0tcmVzdG9yZS1qb2JzPU5VTSAgICAgICAgICAgICAtLWpvYnMgcGFy YW1ldGVyIHBhc3NlZCB0byBwZ19yZXN0b3JlDQogICAtLXJlc3RvcmUtYmxvYi1iYXRjaC1zaXpl PU5VTSAgbnVtYmVyIG9mIGJsb2JzIHJlc3RvcmVkIGluIG9uZSB4YWN0DQpCdXQgdGhpcyB3YXMg bGF0ZXIgZXhwYW5kZWQgdG8gdXNlIC0tZHVtcC1vcHRpb25zIGFuZCAtLXJlc3RvcmUtb3B0aW9u cyBbMl0uDQpXaXRoIC0tcmVzdG9yZS1vcHRpb25zIHVzZXIgY2FuIHVzZSAtLWV4Y2x1ZGUtc2No ZW1hICwgDQpTbyBtYXliZSB3ZSBjYW4gZ28gYmFjayB0byBbMV0NCg0KWzFdIGh0dHBzOi8vd3d3 LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvYTFlMjAwZTYtYWRkZS0yNTYxLTQyMmItYTE2NmVj MDg0ZTNiJTQwd2kzY2suaW5mbw0KWzJdIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3Nh Z2UtaWQvOGQ4ZDM5NjEtOGU4Yi0zZGJlLWY5MTEtNmY0MThjNWZiMWQzJTQwd2kzY2suaW5mbw0K DQpSZWdhcmRzDQpTYWNoaW4NCkFtYXpvbiBXZWIgU2VydmljZXM6IGh0dHBzOi8vYXdzLmFtYXpv bi5jb20NCg0KDQo=