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 1t5i84-007s0u-1E for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 09:03:08 +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 1t5i82-00ERIN-Bl for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 09:03:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t5MFt-005KGm-1Y for pgsql-general@lists.postgresql.org; Mon, 28 Oct 2024 09:41:45 +0000 Received: from mail-norwaywestazlp170100001.outbound.protection.outlook.com ([2a01:111:f403:c210::1] helo=SVZP279CU002.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t5MFp-003Fdw-HR for pgsql-general@lists.postgresql.org; Mon, 28 Oct 2024 09:41:43 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=UW/UsbnwcHfh1eB6OC3kb8gYDIAjRC2+lXIeY8fyqfqJgIBJCpiF0/2oYIEwyavZw/b2CuIAKOVZjhrnCu9v77q5mfXoMGUznPMnBN3qKjTbnEAYpdF6YK1wAawrdYrnyZUKAP8CmIgVMjXbASMoPoDoV096iFYjq/oSOTT0JXbqbHsVFskQ4r41m34F8IX4flY/R5AlnFJ06U5EgE565UUwh+czaLgEnZc51or+QwJjMn/pJvGBNTKCfy1dQOc9Ub+fTz0yUYjUe96mQ9mI5FMK1OxWP4ZdbiHhOYqkYIeCFdWH5fWJUYTqmOLGkI0TbXsfZ8e1vxwN2X1UcvmPFA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=dm4NJQccWAAq3uhLgj4BCzIWbjDCtihlc0eO9dLP3s8=; b=GiLXW5JwiHHgyDaohJ0IkZYLlBk6/a0cUIiI6VaO55NIuXdPV4gK88Ulf1WErmIpMcah2EtOZ0SmqLFeyneACdsZ0eHB5BnPHp3h8NXB9oHs9zg3N52lbP850vEgtrHHXXhKhOUsTWeqq9Svcj7hwFvgz/9j4HtSk+Y323qgL0u/Es6w+Kd622c3Anh4VYtzxwQNPAbCr5vTI5wbozQOyfzp5fitRmQyfRHwyneJL1c8RWwmgeaO03fpf1u1OjDlM3h0Hz+VBoLbJUPP20QJcAh/nFS71PK6umUFaFjzZ1UBzofvwckdateHdiCvyjqYhGhg8kN0nGFKPql2t1ZGNg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=skatteetaten.no; dmarc=pass action=none header.from=skatteetaten.no; dkim=pass header.d=skatteetaten.no; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=skatteetaten.no; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=dm4NJQccWAAq3uhLgj4BCzIWbjDCtihlc0eO9dLP3s8=; b=HVDeZ0YN5Or+q5dtc1kAWJsoZSOqixxol4soow9rdkgcnR6Sii8tr2xMjKPSu1MEV85222HrJfjEp/yn5K45DT2NE91aAxoC7+V6xUsod/rBPGjm14DAGBBGTZkYqXCVNd34312tiP+T9LB1SefME/ULcBOTc+ifR5CHUBA0AnI= Received: from SV0P279MB0124.NORP279.PROD.OUTLOOK.COM (2603:10a6:f10:d::7) by OS5P279MB0742.NORP279.PROD.OUTLOOK.COM (2603:10a6:e10:42::5) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8093.25; Mon, 28 Oct 2024 09:41:37 +0000 Received: from SV0P279MB0124.NORP279.PROD.OUTLOOK.COM ([fe80::fc99:281:86ce:4f32]) by SV0P279MB0124.NORP279.PROD.OUTLOOK.COM ([fe80::fc99:281:86ce:4f32%4]) with mapi id 15.20.8093.025; Mon, 28 Oct 2024 09:41:37 +0000 From: "Reftel, Bengt Erik Magnus" To: "David G. Johnston" CC: "pgsql-general@lists.postgresql.org" Subject: Re: Max size per relation for partitioned tables Thread-Topic: Max size per relation for partitioned tables Thread-Index: AQHbJVNjvvRP0FbHk02v5hcjeoDJmbKU3+MAgAchYYA= Date: Mon, 28 Oct 2024 09:41:36 +0000 Message-ID: <644FEBBB-3AFA-4848-B091-696D2132227D@skatteetaten.no> References: In-Reply-To: Accept-Language: en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=skatteetaten.no; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SV0P279MB0124:EE_|OS5P279MB0742:EE_ x-ms-office365-filtering-correlation-id: 984765b3-a450-49c0-918c-08dcf734b792 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|366016|1800799024|38070700018; x-microsoft-antispam-message-info: =?utf-8?B?UE5oOWszNXRyaUZkODl3UkVuRzJGQUF2VFJUS0xsZ3h6bHlSWlFqU0V6WmFK?= =?utf-8?B?c2M3eHhCUHRLL2tqQ2ZoRVJJZFVqenZLTFlhWXdHeGg4c2RiZ25WU1d6WTl0?= =?utf-8?B?LzhIdFhoN3BLeTh1b1BwaitHbG4yTXVScHNHRHJIeXRlNlhtWUNGZW9xNm1o?= =?utf-8?B?U3RDRncxd1ZWUnFNdzhPQUk1dDJJTDI0SWh3Vksrbk8reUE3dlhqNEhjU0gr?= =?utf-8?B?YlhhM2N1MENyMWNVSElXakh3Z1M3UzVvbmg0SG14WjFOc280R2NFT1kxa09T?= =?utf-8?B?K044a2xZbXZwektCS3V6RFJ6REpPWlczUzM3N1BLZm92MThqVkVzMXZ2SFFp?= =?utf-8?B?Zkh2SDJQeDM2Y1F0UGpUa2ZIY0loNmlZcjdIYnVjL1Jma3lxeFlIbEY3clAy?= =?utf-8?B?eUFrL0NOT21qdjViOVdJaTI4U1EyeW5hTUlrWmN1SHBQOUQ0RWpwL3RqWmVJ?= =?utf-8?B?LzBTNVFwcGNyRVQ0Rk1HTGx0RkhmYjlocDErSzJXWnlZVWFNWGg4ZTFQZjJB?= =?utf-8?B?d3dBMjU3YkkyLzc0Tm1WZ3BOTDk4Szl6bGgyaEVXNDZqVUJpTUwrenAvcE0y?= =?utf-8?B?T2EzSmkvQnU5REpzNU44NnJsM3hGZFBUOUptZjJYZk8yQ1RiK1BQVWhZU3Fp?= =?utf-8?B?cmlWRncvd3N4TTFsdzZDaDZqdWh3V3VVYTRHVm9WUVQ1TnNsVVEzWXZKWksv?= =?utf-8?B?ZDVKdEtRVVpnOEJxM2xHemlIY3lTSWt2OGNhWk5nY2ZrbHZ6cUFzS05WMTZJ?= =?utf-8?B?UWVGNnY4eVcrSUNFR08xMUVjVEdwUEpWV2hWVUJoVDZNb0dwZk10MHdONkZj?= =?utf-8?B?aisreTlPWnh1eUg5MHRNUy9sV3NTUE9ZMStKOERBcFJONlBudzdMR1FIK2hY?= =?utf-8?B?NGo5RVZpYkFPRlNqRytuVTU5SUNSQk1wSUpQbU8wL1BoN0FUWVJ0bW9KTnZ0?= =?utf-8?B?ME9nQUNCUnVmNE5ialExS2F2NFlBbGtKQmh0YVp6ZWhRMjVCUDRjbFhXdWhV?= =?utf-8?B?K0JJOGYyRTd4Ky9BeDF0OEdBTzh4SHlFL2pzK3NJUWVDMVhhZS81TDBpOWRl?= =?utf-8?B?dFBQMWNHRlIzV3oxNzRKcEFueDVueGJDYVVvalNlMXZacGRwajRqRjVJa3pN?= =?utf-8?B?dXo2ZVpzMzF1QmMrTis4NmdZRTU5OWhyNFhMc082Q0pGdVFVNHpoSHhpelRH?= =?utf-8?B?ZW90VG1IQSt5cFh1UmpCTWdNVGU5cEtrNzE3QXp6M2JEbDlKS1ZzaXNOYnpu?= =?utf-8?B?dVVCemZldkZSRzhrdjRMclFLMHhYSGMrYkN4Z00vTmhOTVlVaWE3NnZCbjhI?= =?utf-8?B?YTRySlcyZStDK3hNMVo5MVFKSzBZelh0WU90MEpRb3poMk5DTWo1Ymw4MkdF?= =?utf-8?B?ZTVJclRRMjBYTzFjcEZiejF0ZmRQdUVURXVHWjhkdEJNZk9qNUpFcEUzc1RU?= =?utf-8?B?ZStlQjh0S0hmUlliQnpBUDArK1R2dVN0ekREQndDU1d2d2l5MHdjejBCQWRh?= =?utf-8?B?bmp5R2JldDVkWU1zaWg2QmoyM0FWTFV1M3Eyc054Rms4b0EyWWw1Q2pnZHFL?= =?utf-8?B?dTBBZEhBYlN2REIvbkVnbFllR0RwNGRScitxa0YrVWpnNWlUQ1NKb3ZyZTBC?= =?utf-8?B?SHlVdEp6S3JTSHhCd0Npb3FjbEV3OXI2MnpORlZlZk1KYWxvZ2FpSzdnMDM4?= =?utf-8?B?OGdRc3BMSTE0cmxGaWg0L2U3MW9TUlFOSDdPK05pZWlRMy8vWXdVenhMa0h0?= =?utf-8?B?azhaeHpZa0U5Z2hYMXJ1d0M4Y3AvTXpJSEZrVTlCRzlSZlFiWEdMUTZ3R2VD?= =?utf-8?B?OUFMUTZGbFpCVmdrY2YzaW51c2hTMU1PMDNnZzA1QjlVUlUxQ0xrbXhsMURx?= =?utf-8?Q?cY7CWxrS4Xj0S?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SV0P279MB0124.NORP279.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(376014)(366016)(1800799024)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?VEtXTlFBR0Z4QUJsMlQ3V2tkd2hmdm9BVWpZUEtPbHhUWi9Xb3RrTEREVHNj?= =?utf-8?B?clhMY0hDZGowTTNDZnFSakpxVHZyTWV4OXI3US9rMzRURWVOZkN2UGRGRHFk?= =?utf-8?B?aVdvQWdzMWp0eFNkM010TU9WbmZlQXhUTE9oN1dsZ2tZWm4yTWZzSlFpVDZX?= =?utf-8?B?eVlnSThzVHRCNHEvZ09NSC9laVJxZEd2aXNJck9PYlpma05qUW8yT2RuRG1C?= =?utf-8?B?WXBDRTA3dnZ0dTd3b3VOejg4Z2tRUmFyUEgwTzdWdDJ4NUtKTjJWL25VT3hU?= =?utf-8?B?aitadzNJbmcvVmhkRk5EanZZbWphUEdlWUZrd3U5SHdHSXNNakFhb2w3UXZu?= =?utf-8?B?aUlSODRXeEhRQTFEZ25LWlRUY2pFbHZoRElnbkF4ejRXYStZbkh6ZHFqTzBv?= =?utf-8?B?NExXQnIwMWNhemRVZUE2ckRYUGpxazJFN1JZSjJYMzVoL1NJbHorMXNtYUhN?= =?utf-8?B?WXEwOUNSYjdORFd6UEs1SElrOGFTY1ZjTDV3K3pmOGRQK2s2NzVPZlVnVFJY?= =?utf-8?B?WlNPUExhY1FwQVoxREJqMjNNNUgybGhxSTFKT1pCZHhaUFdVaHc5U2JhekJT?= =?utf-8?B?elRaNDE3MHFEWTlYcnNPc2t3c2tIZUx4M0JkZkVFM0V6eC92Z1VlbEpLQnRF?= =?utf-8?B?MEdjcEdxc0pLZHJpeHNwVngrSlBqWGg5WUlmZ3ZQeVEvWVhEOTVoc1lsRVIr?= =?utf-8?B?SHpCbkNNSXpoMXljWXl3QlBVak1PRmhxY2FZZWRXZWlsUnVkR3ZRSXpNMU8z?= =?utf-8?B?dXR2SjRQcEhnNFYwYTJkQTZQck1rK1FYRE1Dbm9VUVk2ekEydEd3cExEdTV1?= =?utf-8?B?dUFLOE5DMjFob1BxTURjamdCVElaTDN4cGVWU2IrUHBLejdaM1FSS0VOd24z?= =?utf-8?B?dnpKQWNHeHNXYnBiRVBGcnZEdG5vNWc1ajltSzNETHNDa3NYYjFmaTFJY3BO?= =?utf-8?B?UEd2WkU0K0hPMnpaWEdJbGxQTnhXZlhQenIrMWM3SkpUSzZla3VjOVRXamhp?= =?utf-8?B?MW5aM3hSV3hPNitLSWJvUG1sUXZ5SjdkWEErSzV0ekFLZEhsY2ZtK1g3VWJI?= =?utf-8?B?QU5TdHFhYzFUdE1xNml4MWdvWVB0VmpYSEZCOGdNb0JRSlg1T2ZQcG9TcjJO?= =?utf-8?B?N3h2MW9melo5dUd3UjcrWGZRazFBa29JWlFFR2lTRndVbTByVzVCVlk0VEd0?= =?utf-8?B?YTZMQ1RBbUxnRUJFa3hjUmljQ3ZVcXRQbGdMVkdDcy9QMEpWY0pWdmFLYzdj?= =?utf-8?B?ZFhTMXUwVnc2ajYvVkR0RWthc2hVVVJjMlNjUmw1TExtWlJCL0cyVEZNSERE?= =?utf-8?B?cEJUNEorUEtSTHVDQ01iOGEwZWVQVEtZbCtubnoreXFmT3QyNUpXK29LekJr?= =?utf-8?B?QytKRmVNSVhpK3Z4ZEtzeUp5Z3ZmdUtianFaSkxPWjk3alVTVkhLZ2xaUDc5?= =?utf-8?B?eXBjVnRuL2p6YTZIaTBCdmNrbUg5V1VSUEUyR1dtc2FXcWw4WDRQbFhTbnFp?= =?utf-8?B?KzJlcFZDOVR1emNUZ3VzVEVUb1ZZbjRHcDloa1V3bEtacW54NFhjOHA1V3J2?= =?utf-8?B?RWJsaTZjdlhHbVZxSGs4SUx5anRwYzVDK0g0M1plN2t6U3JyNUlGNG96VHh4?= =?utf-8?B?MTFGcG1YTWUxR3g2cGhFeVdVYWZQNXd6SGltdHZZaU1WclNJaUlaVld0bGVS?= =?utf-8?B?aUx1amE0aURRUU15UzZlZlg1eFZEVkVXZUt3R2pJQStrbm45SHNiSWtOYlN4?= =?utf-8?B?RnBXbzhwc3JYV3RiTEo1N3ozVDZuMHBLMTRSWithNktPSnYwZWs3ejVVYlBp?= =?utf-8?B?bDFYNzJicnBoMjVubnpsV2M1LzZtaEk0NmkrUHhuN0ZmajRZaFArSXB4cFU2?= =?utf-8?B?c2tqcWlpeGs2Tm5uQVE4QmdxZUhnQVFjbFdYV0Y3eDcvSHJ1a0g1VDFlMjV1?= =?utf-8?B?T292REFyTnBQZk82UldIRkVkWWdyRENRUFVLUGtqL0lJZ1ZqMnRlQ2grOHZE?= =?utf-8?B?Y3FBbmZzUnA2RmlEZkRFZGZ5V3VQYm9Ma3BTaWt1Z3kyRjMyQ1lvbS9UbjZx?= =?utf-8?B?RDhkU1M3eU5pc0FUNStiR0M2VWs5SGZSNlA0am5teEhMK1J6OVVzUlNXMisv?= =?utf-8?B?c3JucnVOS29SZnoydjUwL0U1WGw3Y0VRVUREVzRYQUtEODlOZHN2YUZ3UENz?= =?utf-8?Q?R6ce8euvIZS6GOJA0IGX7oA=3D?= Content-Type: text/plain; charset="utf-8" Content-ID: <28D476FF4CB4BC4FB2E2B276DA03477B@NORP279.PROD.OUTLOOK.COM> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: skatteetaten.no X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SV0P279MB0124.NORP279.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 984765b3-a450-49c0-918c-08dcf734b792 X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Oct 2024 09:41:36.9573 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: c9b0d3b5-c035-4c08-8136-760ae8c28600 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 2EmOqGKcOc5dzL2Obujw4aNh2RD8OO4P7HsmZkYxvl+9AL/OadkJUKZ6ddQR7gVvVxqKVuN2w25n8Mpc6RhYsMoxDq3qOKW/uYIO+m94kbc= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS5P279MB0742 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk V2VkbmVzZGF5LCAyMyBPY3RvYmVyIDIwMjQgYXQgMjM6NDgsIERhdmlkIEcuIEpvaG5zdG9uIDxk YXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNvbT4gd3JvdGU6DQo+IE9uIFdlZG5lc2RheSwgT2N0b2Jl ciAyMywgMjAyNCwgUmVmdGVsLCBCZW5ndCBFcmlrIE1hZ251cyA8bWFpbHRvOk1hZ251cy5SZWZ0 ZWxAc2thdHRlZXRhdGVuLm5vPiB3cm90ZToNCj4+IEFwcGVuZGl4IEsgb2YgdGhlIGRvY3VtZW50 YXRpb24sIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvY3VycmVudC9saW1pdHMuaHRt bCwgbGlzdHMgMzJUQiBhcyB0aGUgbWF4aW11bQ0KPj4gc2l6ZSBvZiBhIHJlbGF0aW9uLCBidXQg aXTCtHMgbm90IGNsZWFyIHRvIG1lIHdoZXRoZXIg4oCccmVsYXRpb27igJ0gaW4gdGhpcyBjb250 ZXh0IGZvciBhIHBhcnRpdGlvbmVkIHRhYmxlIG1lYW5zIHRoZSBlbnRpcmUNCj4+IGxvZ2ljYWwg dGFibGUsIG9yIGp1c3QgdGhlIGluZGl2aWR1YWwgcGh5c2ljYWwgdGFibGVzIGl0IGNvbXByaXNl cy4gVGhhdCBkaXN0aW5jdGlvbiBpcyBraW5kIG9mIGNyaXRpY2FsIGZvciBvdXIgdXNlLWNhc2Uu DQo+PiBEb2VzIGFueW9uZSBoZXJlIGtub3cgd2hpY2ggaXQgaXM/DQo+RWFjaCBwaHlzaWNhbCBw YXJ0aXRpb24uDQoNClRoYW5rIHlvdSEgScK0bGwgdHJ5IHRvIG1ha2UgYSBjaGFuZ2UgdG8gdGhl IGRvY3VtZW50YXRpb24gdG8gY2xhcmlmeSB0aGF0Lg0KDQpCZXN0IFJlZ2FyZHMNCk1hZ251cyBS ZWZ0ZWwNCg0KDQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KRGVubmUgZS1wb3N0 ZW4gb2cgZXZlbnR1ZWxsZSB2ZWRsZWdnIGVyIGJlcmVnbmV0IHV0ZWx1a2tlbmRlIGZvciBkZW4g aW5zdGl0dXNqb24gZWxsZXIgcGVyc29uIGRlbiBlciByZXR0ZXQgdGlsIG9nIGthbiB2w6ZyZSBi ZWxhZ3QgbWVkIGxvdmJlc3RlbXQgdGF1c2hldHNwbGlrdC4gRGVyc29tIGUtcG9zdGVuIGVyIGZl aWxzZW5kdCwgdmVubmxpZ3N0IHNsZXR0IGRlbiBvZyBrb250YWt0IFNrYXR0ZWV0YXRlbi4NClRo ZSBjb250ZW50cyBvZiB0aGlzIGVtYWlsIG1lc3NhZ2UgYW5kIGFueSBhdHRhY2htZW50cyBhcmUg aW50ZW5kZWQgc29sZWx5IGZvciB0aGUgYWRkcmVzc2VlKHMpIGFuZCBtYXkgY29udGFpbiBjb25m aWRlbnRpYWwgaW5mb3JtYXRpb24gYW5kIG1heSBiZSBsZWdhbGx5IHByb3RlY3RlZCBmcm9tIGRp c2Nsb3N1cmUuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQgb2YgdGhpcyBt ZXNzYWdlLCBwbGVhc2UgaW1tZWRpYXRlbHkgZGVsZXRlIHRoZSBtZXNzYWdlIGFuZCBhbGVydCB0 aGUgTm9yd2VnaWFuIFRheCBBZG1pbmlzdHJhdGlvbi4NCg==