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 1t3jDO-00EKDG-GS for pgsql-general@arkaria.postgresql.org; Wed, 23 Oct 2024 21:48:26 +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 1t3jDM-00Ddlm-Kt for pgsql-general@arkaria.postgresql.org; Wed, 23 Oct 2024 21:48:25 +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 1t3jDM-00Ddld-9J for pgsql-general@lists.postgresql.org; Wed, 23 Oct 2024 21:48:24 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t3jDK-002d0w-2f for pgsql-general@lists.postgresql.org; Wed, 23 Oct 2024 21:48:24 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id 006d021491bc7-5eb9ee4f14cso103465eaf.1 for ; Wed, 23 Oct 2024 14:48:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729720099; x=1730324899; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=zS+yhFFcU+XIj8suwpe8x5Wuf1xDycMiwA1hSJNIgvY=; b=W///5e4el94FkabOl1B+JySXI4kIy7Xb8aX3weIoOMjaIT7obZo47V68DlbMXpP9T6 uDAfxcYaS6TyTdBcn9uQWBr9xjkUzgPASe10d/eub1ApNeRUi/7/p4ALwO908GXXpvW7 Rcgasd2bivq1sC7tBIFGvU+1clxDNWehsWdD/cvxJTAhq/ELcQtF9vjRxsneZ6zURE+O LxnQFssCZ7BN2B0nDN/3icG49SK1cQ7224Rlrz/ae6p8Zwpwy2TL2uXSYjqZ0PNoS8G5 P1aCz+1BZh0hDhUVfHXAr8dMWWYVyGWVGALr2JuTPOi4osiqDl26A/xotvdMU2USN/SS lUpw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729720099; x=1730324899; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=zS+yhFFcU+XIj8suwpe8x5Wuf1xDycMiwA1hSJNIgvY=; b=e+qgkwtAkifb3a1sAVe3KyfJEvGK0qU9uXcqSXABVz2NY/g+MYeiGKCDwKfOZcAURO MUfwLASS6rFsI5zlJvJzJM66KL1xsokQ2eypAo7kqnVFDXl0ET/qik5g8/dDzXiNhNg3 ZIakEurH5eyBNQ4Jt2X7CAm/vmSAp91dk2+ids/2Az593Dx2rO16sH6bloS4Z9SEZRB8 rzlT+BSXqMmnjUGlokFFudzEIGxFkX9cCBCmo5Kz+H8dncM+xUjDphsa2NFzLwk+DetJ 58iOOIKvOCCm2p9su6Vj+WK28kGXT/AmRNwDuQfi9RQjTzB4qk4TY2PVHn2xi+3QKCML GP1A== X-Gm-Message-State: AOJu0YyqrwK4ylWt6ilfpRPdyasHlUYbHID/amkuPbJeJuT8rR7iImam HIpPnk9IMgeTHoqHiaCAsxlGosj0eKijk2HtMCDzEyI7WSPhTM1LDHJsMnKcxtyikpQ8FxCTc3x NkyJ2C0xerfGbktRgZ/x+nbFI8RY4gg== X-Google-Smtp-Source: AGHT+IHDgAXsnYC1sWx9+yY8NAenj0DBdRX0ziF2iDsh36/hAdwwP89TxWuY6cNfzkGO+qzO1HRa7o6AOu/HM10tQV0= X-Received: by 2002:a05:6871:707:b0:288:41d5:bcc6 with SMTP id 586e51a60fabf-28ccb7cc151mr4607214fac.15.1729720099451; Wed, 23 Oct 2024 14:48:19 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a8a:15ac:0:b0:56c:c9af:3ee6 with HTTP; Wed, 23 Oct 2024 14:48:18 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Wed, 23 Oct 2024 14:48:18 -0700 Message-ID: Subject: Re: Max size per relation for partitioned tables To: "Reftel, Bengt Erik Magnus" Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000016bc2c06252bd8c9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000016bc2c06252bd8c9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, October 23, 2024, Reftel, Bengt Erik Magnus < Magnus.Reftel@skatteetaten.no> wrote: > > Appendix K of the documentation, https://www.postgresql.org/ > docs/current/limits.html , lists 32TB as the maximum size of a relation, > but it=C2=B4s not clear to me whether =E2=80=9Crelation=E2=80=9D 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 ou= r > use-case. Does anyone here know which it is? > > Each physical partition. David J. --00000000000016bc2c06252bd8c9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, October 23, 2024, Reftel, Bengt Erik Magnus <Magnus.Reftel@skatteetaten.no> w= rote:=C2=A0

Appe= ndix K of the documentation, https://www.postgresql.org/docs/current/limits.html , lists= 32TB as the maximum size of a relation, but it=C2=B4s not clear to me whet= her =E2=80=9Crelation=E2=80=9D in this context for a partitioned table mean= s 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?

Each physical partition.

David J. --00000000000016bc2c06252bd8c9--