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 1t3jAS-00EJxT-Cz for pgsql-general@arkaria.postgresql.org; Wed, 23 Oct 2024 21:45:25 +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 1t3jAQ-00DaIS-2L for pgsql-general@arkaria.postgresql.org; Wed, 23 Oct 2024 21:45:22 +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 1t3bva-00A7Hk-8X for pgsql-general@lists.postgresql.org; Wed, 23 Oct 2024 14:01:34 +0000 Received: from mail-norwayeastazlp170100001.outbound.protection.outlook.com ([2a01:111:f403:c20f::1] helo=OS6P279CU014.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 1t3bvW-002SkW-MC for pgsql-general@lists.postgresql.org; Wed, 23 Oct 2024 14:01:33 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=IHutsYUf6hwKugB/mDyE7gyxTPiVAA9dPwGYxXEEo4/FA+Hl/ca/eVOmZ5ec/IaHzAh4v124u9mNLC17rE5YOz4xZhFx1kgybgeRPvE1ia/P7bA2YNnUbrRf3Mc60XXQqvaJRFFWKJ/3Cu49t7CCD+R3wZRA07QZWqaEcxlp5mMkJp9BRvVuZOMbYg3TMp5mLjz82vm6aTEgnneWQPc1JMiVqWsuB4AxO4NUPGDzkX9mx1pfHU8CJ48JCikXkObiYgqOPHNwYGFWPeURD/ssTmsJGe8jeLYT0dy4RzX20LaISw71G87nI+1Fj8vUnoVX+S22PSe9Lk8/ENP5vi2/Jw== 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=Eahe+9EdtMz+LWH9g50ju1TCffBXo5pqGmEYbMvPpKc=; b=gDh/p7fOKHFmsKZnS8O+sO0NMC/uhypPXYZA2eW6Duf3r6dFio4U2rqNeR9P29hCjahzgNkMw2GVSZ/oXHSZdG8WhBWGv06BE0d81TXeuRgokS64r5+AoHAfs/Rf8P1Nx5/BjCjTr/lXHdYO81/5UaO7R480pUrqQeY1MLdRKGLheWxW7s+B/JDFLgVeU2F3LCoNfF4c0fhQk+bN9CNtG6kuRWM/Yw2zBlGSxcCyMOgTM96ElldQpBYi1zfnZ91bsf8+M7XOPbM3oDyHn2BnEexmGV6AbTRLskt75WTUyaE0rJv8D2BdyMSdUxb8gf2i4AGpWnns12ZiQhfWz/Lmjw== 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=Eahe+9EdtMz+LWH9g50ju1TCffBXo5pqGmEYbMvPpKc=; b=aYq5adzulKfvwVFd4VBSd31saf2PDM4NZEGMP48qAco73z5CHKcUwTZgKghV9aBW0mcy8ySkZLWclkYGiW9tqFV4Edvw39PG1RVtpSnsZXRI0boV8cvF+/UiULSMyHOIiGpRFtOwzctQdmtvgfmKl3Ax/WBybKfuSNg0ar34zr8= Received: from SV0P279MB0124.NORP279.PROD.OUTLOOK.COM (2603:10a6:f10:d::7) by OS5P279MB1053.NORP279.PROD.OUTLOOK.COM (2603:10a6:e10:58::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8093.16; Wed, 23 Oct 2024 14:01:24 +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.018; Wed, 23 Oct 2024 14:01:24 +0000 From: "Reftel, Bengt Erik Magnus" To: "pgsql-general@lists.postgresql.org" Subject: Max size per relation for partitioned tables Thread-Topic: Max size per relation for partitioned tables Thread-Index: AQHbJVNjvvRP0FbHk02v5hcjeoDJmQ== Date: Wed, 23 Oct 2024 14:01:24 +0000 Message-ID: Accept-Language: en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_68ed6534-701e-4052-b9aa-6ed330ffc3a5_Enabled=True;MSIP_Label_68ed6534-701e-4052-b9aa-6ed330ffc3a5_SiteId=c9b0d3b5-c035-4c08-8136-760ae8c28600;MSIP_Label_68ed6534-701e-4052-b9aa-6ed330ffc3a5_SetDate=2024-10-23T14:01:23.9410015Z;MSIP_Label_68ed6534-701e-4052-b9aa-6ed330ffc3a5_ContentBits=0;MSIP_Label_68ed6534-701e-4052-b9aa-6ed330ffc3a5_Method=Privileged x-ms-reactions: allow 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_|OS5P279MB1053:EE_ x-ms-office365-filtering-correlation-id: 5f712b38-c59f-4680-4a51-08dcf36b2e78 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|366016|1800799024|8096899003|38070700018; x-microsoft-antispam-message-info: =?Windows-1252?Q?VsNvpGXBP/CdLVAnM58eY92R/JMRN14zaROcnjD0+2CheHDy9o98cueA?= =?Windows-1252?Q?PEfaBwmZkhR7m8PVYwcBePpREYJg9j9j0tO5ZbMUGAyB27Yvl3sHpLV3?= =?Windows-1252?Q?hKXeRAv2SHxujyGzMUZq8fzWzUrR5W/ASkFQNo5jhymRPhwMy2K78Y7P?= =?Windows-1252?Q?7r4Y35sB0aMOkvo77oOZ3z9zl05n9OZtN7FFceDhN1pY3cgahXpYKtA6?= =?Windows-1252?Q?X48NctP7hrtpmpMEyeFaGEEo84uabx9ugk15I7LhDHdVX5TzN2LBerUx?= =?Windows-1252?Q?1LtJUwYvutY5vuEE7QklKV9AGB47+FuZj6EGaZgHPDvGn0DuysfAdtRb?= =?Windows-1252?Q?soZSEZypbbZq0lWX/hAxKckHiGYnw52ePU1xH4VNKlulXwhbHO9Iaiww?= =?Windows-1252?Q?1cNdxQ+ioPBLegrkgEJV+nwDt4qDMfOJHhVv/5M4DmqK3gScPiw5JQ1G?= =?Windows-1252?Q?dHZ3k9lMBdiNP11Nq4LOrWXXSkC+FJEJ5VSsWNHClQnujYFcISY6XD5D?= =?Windows-1252?Q?tuX+k7uE9xaNx8bHrKKAREiz9n7mh76U4i3kwC3kej1+MQ1Cw0cTwvMA?= =?Windows-1252?Q?9H/V1h6JsPZTa85BUvXQnUCCisaBMPuGXaomfsbI0vLhq4MWNSwtYDvx?= =?Windows-1252?Q?vSRXTkVSCLpGhHQdFXSWISvduLmn95Fgvybr48VBQft0OJJ048Bancgu?= =?Windows-1252?Q?Uow6jU5AWlMvmavg1lyclXxzuzuU4Wkr3UXrosbD2UZ2e9sDOjUwh/w3?= =?Windows-1252?Q?Mg/QSGeQu074i9gxQiOJiRnsesadi92vqwAv/W+RgaRGjapPhEeayUBy?= =?Windows-1252?Q?xOouBfYMeky5hMLIS1j8r2HNqDJtVixcIgJO/6k/jtZfptZPGngxRXO7?= =?Windows-1252?Q?1PPznIQ0GX9N9jaR0pDNEkSvjDyRWnO5uDBOcLrW1ktVzFa5XBTnycVb?= =?Windows-1252?Q?N+ZusIZk6C4nLN+uIWeciaEinlNgkXurr6HL1T5tQBoFHQUbO7iNbrzc?= =?Windows-1252?Q?JzAFbML966BwaeqxJfiKSF/53wjYNtp3Qwhov0OtyuuORRnofRcy3UJS?= =?Windows-1252?Q?hDRxtHcqYKHVQqdRJXWqJdgkAUj3OgFPlAKbze6wO168Pw2WSNJ2zvBY?= =?Windows-1252?Q?wCFBL2b4iCwcXtAaRd3Xhg6q0jExflhHt0vBI5ZKuDsKL7vQlpXsS5ju?= =?Windows-1252?Q?UJJuP5NzISTtLEX1m2lChxkoRkQJVuhqNEZHNt5y/3VrAIVIgYoGgq9a?= =?Windows-1252?Q?ACCqZ/kbVWVbVbLeULxA7zSOIDN7w+NcQ31RP56q7+DpBrkbkzZoP4Lg?= =?Windows-1252?Q?JriuZLCMbWhUsWahdPCXHndK7nVBxR9UZNIL0/Wm+lRKCM75OOfZREiw?= =?Windows-1252?Q?uO28O1yqkn8tcyrM4jGQ9WhKEUjk1t3LrE6nFMxiKA/fby3pMKMBec6J?= =?Windows-1252?Q?1YsVgL6wOjUdJs/qzqHTOKRtnaO+Lyp5EMtXeIgdehpGNvSGkQRTOSOb?= =?Windows-1252?Q?Eiih6xne?= 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)(8096899003)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?WX33Q9HUyLMGeSoVwulkdJkuxuHYaa3XjekhaOfHD+x31in4ZacjfepZ?= =?Windows-1252?Q?GRfrqCtZ3W98GNvV45J0Vp5gS37Nrh6LzMyx9KxFunhrRBpniNP3ZLv/?= =?Windows-1252?Q?XAEEOfu+XC4BbciM/00b/v9j2kVUjc/Md6zvIS9RD95BvJYvXBH6k2pP?= =?Windows-1252?Q?JfMhBm7HIcaAhIUKK0T5EfIUQT9KDM5BQJ8NUT6VivIsYulVj2QiS0gW?= =?Windows-1252?Q?Z1hKK4jo8Km4A6xHGML8iKrXe4cWzDoQ50QqbVCLgDDm881bjnGZ9tU/?= =?Windows-1252?Q?Vl4vs2SHMK1Puuei6hv5n/AGU6bA6+r0zK9/3TrSw6F7oBFaPgTe1VX5?= =?Windows-1252?Q?x5YbkuKHc3QJ5JIrIBtai0N9Vot88Mcba7Lfuh/6CVnHBGYAl24Idtvn?= =?Windows-1252?Q?R4ytgI0hbR8di+0kCOsUY3WqfZKja5fjhT9fLO/ndBVkGS3jwOO2Gf35?= =?Windows-1252?Q?6jVsk9hkbmb+2rYhmOtcobCXcQpf8aD7J1VCXKx7cjhanrI1GZaYokdu?= =?Windows-1252?Q?hDCUwUSuta9bZwevJsjVfFsJQvEd92Eqb8He2bnc18+/OwkBOQ2dapnO?= =?Windows-1252?Q?QQrYgTUyysmNfOaFUbtlw8V2gK+YfTRuveQa7ZOrFzXUxtZgkXpsgXC3?= =?Windows-1252?Q?KLkGjc2t61lq6qursPwH0QEwAlgxynPPBrSGNaoIWB4iPU6Frb7xh5Tp?= =?Windows-1252?Q?lTL6NxCg8ysmo1BAu90r8ZxhW7RixtXyQal6XYKdmOuY4Rbwa1erJzzp?= =?Windows-1252?Q?OO6VtQxuDt0l3oQ2hV3zcNXYltAQTsNVBR056N0XnQMn+U4Ok1qE5U0/?= =?Windows-1252?Q?yD3mtOCpbl+Z7Xax4BMeSxSZIWDesBDFgknj4u2jPzCUHF2H9pQu1U/t?= =?Windows-1252?Q?wx87oTOxxvbHz7sog0Or2ffiJDsovVrGu2AiL8VAJDqvNzlLcNQpNQs7?= =?Windows-1252?Q?3tqYEGHxW1o2Cpw9x2cg16NQFl7LdRge3hRBhPZ7GneNP6SW2BmectGL?= =?Windows-1252?Q?YGDTUybXJz8B8kqOi2baSPJu1wYPTGPQWQ+Hr0eXDMFd+UD2E9x59n0G?= =?Windows-1252?Q?PU1YfVJGssELa8GnjPYO+PEMG8D2NKWyDF7w8VFMSC8JN6xDqb+mHbwa?= =?Windows-1252?Q?vDSbU8fCdwrJnyvLLpje0fIv+P3+7LpzRHlgqcN5mLUHwvd10aGoGuvS?= =?Windows-1252?Q?gnwMWt+3jHZWLZwORmStsefF9e0caZeQVardc98bKVZXkU9cfneWzbf+?= =?Windows-1252?Q?C3qa4QZS0Zilaj1c8jBXLne5TTFMIOEb+kM3uyexlFRipHg3rpmlRr5E?= =?Windows-1252?Q?DJoN6juRf3joLCclvehYKXxHlPAiWNIAM+lf+tHjXfdJTzaVHPD/nYOv?= =?Windows-1252?Q?x8PwHTjEtJ4/wl1hIZQJKah4P8J4wSxuB/ZDg3J2OUTw94cAjzPXteyc?= =?Windows-1252?Q?Q1YeU5oVh4Awr2ZLdDTrpqHAXq1UDks0syfurgJi8sTz/D2tfiCPqy29?= =?Windows-1252?Q?rQOx8gTuiyis9ZJmC3b7R9di4hXVVXCujdnkJMnFaIt1aZ+hZN9jnePH?= =?Windows-1252?Q?SsTXOsFWZDsgNQCVFUKi3JdbIbxaqmIwv6PXf6EKt1bJ0YLCvKwxLnoX?= =?Windows-1252?Q?vBHzt71r/4QO2OioXFCWvFeM/PqkITDdTkJChIcEsRrvG0EImkg27nfn?= =?Windows-1252?Q?9tX4+kENQ4qse3qQvgcCIB5Q4H6QoyZHYQq47Psmwe2tXMRaodmvOE2e?= =?Windows-1252?Q?D+72N+GR+1RF6Ws8fcw=3D?= Content-Type: multipart/alternative; boundary="_000_SV0P279MB0124BF75CFB8A054CE0C1538E74D2SV0P279MB0124NORP_" 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: 5f712b38-c59f-4680-4a51-08dcf36b2e78 X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Oct 2024 14:01:24.6332 (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: 1Dma6yGMI2sROU/CaFtTpCEX5jvUeZCjx9a+BJGsM49JVG+I2XL1qjXanz3XYCi5sUt55wRg2QE8EEOlodlB/d3rQYhqVQ0g78Gqi/vm8xM= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS5P279MB1053 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SV0P279MB0124BF75CFB8A054CE0C1538E74D2SV0P279MB0124NORP_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable HI all, Appendix K of the documentation, https://www.postgresql.org/docs/current/li= mits.html , lists 32TB as the maximum size of a relation, but it=B4s not cl= ear to me whether =93relation=94 in this context for a partitioned table me= ans the entire logical table, or just the individual physical tables it com= prises. That distinction is kind of critical for our use-case. Does anyone = here know which it is? Best Regards Magnus Reftel ________________________________ Denne e-posten og eventuelle vedlegg er beregnet utelukkende for den instit= usjon eller person den er rettet til og kan v=E6re belagt med lovbestemt ta= ushetsplikt. Dersom e-posten er feilsendt, vennligst slett den og kontakt S= katteetaten. The contents of this email message and any attachments are intended solely = for the addressee(s) and may contain confidential information and may be le= gally protected from disclosure. If you are not the intended recipient of t= his message, please immediately delete the message and alert the Norwegian = Tax Administration. --_000_SV0P279MB0124BF75CFB8A054CE0C1538E74D2SV0P279MB0124NORP_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

HI a= ll,

 

Appe= ndix K of the documentation, https://www= .postgresql.org/docs/current/limits.html , lists 32TB as the maximum si= ze of a relation, but it=B4s not clear to me whether =93relation=94 in this= context for a partitioned table means the entire logical table, or just the individual physical tables it comprises.= That distinction is kind of critical for our use-case. Does anyone here kn= ow which it is?

 

Best= Regards

Magn= us Reftel


Denne e-p= osten og eventuelle vedlegg er beregnet utelukkende for den institusjon ell= er person den er rettet til og kan v=E6re belagt med lovbestemt taushetspli= kt. Dersom e-posten er feilsendt, vennligst slett den og kontakt Skatteetaten.
The contents of this email message and any attachments are intended solely = for the addressee(s) and may contain confidential information and may be le= gally protected from disclosure. If you are not the intended recipient of t= his message, please immediately delete the message and alert the Norwegian Tax Administration.
--_000_SV0P279MB0124BF75CFB8A054CE0C1538E74D2SV0P279MB0124NORP_--