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 1t5jgQ-0081Wm-Pk for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 10:42:42 +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 1t5jgO-00F9Oe-Vm for pgsql-general@arkaria.postgresql.org; Tue, 29 Oct 2024 10:42:41 +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 1t5jgO-00F9OW-Kr for pgsql-general@lists.postgresql.org; Tue, 29 Oct 2024 10:42:41 +0000 Received: from mail-lj1-x22e.google.com ([2a00:1450:4864:20::22e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t5jgM-003Zu2-QA for pgsql-general@lists.postgresql.org; Tue, 29 Oct 2024 10:42:40 +0000 Received: by mail-lj1-x22e.google.com with SMTP id 38308e7fff4ca-2fb599aac99so48579641fa.1 for ; Tue, 29 Oct 2024 03:42:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730198558; x=1730803358; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=mcRu5LSj7o3mj8jZV6YfENf5QC6Jik3IOxqvjSlIswM=; b=OuMofLzvmIgyTqcjUsG/+7oaQfysRmiRi6FkxjgYJpEHQxVdYtYomUfT3ewg1tP6ho oCw6QsnWn1oX+20ZlLtlU57t+rPoYWVAGtZHoqF5Qi0EgXgHUVhMA48ZmPt6YXDbk3SQ 3T9i5L4OjSwSAB/8rknUtxhevxvCiQ8Hk9JQFKhxy+fthwoopDD5mat0hst2wc2NZHNF pl7sogn68KNDhEH7eZkS7aVJb5TpkrQp73NEFtwMVeCipq4ikcxt9B4h9MdnBiYFGXdi Ro2osVUIN1sD1SB+wFnMR/4FTMofvPBaMhAxweHFLrsOTsoijXlt/C8zsoFHcP6C3Fkh 6Ugw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730198558; x=1730803358; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=mcRu5LSj7o3mj8jZV6YfENf5QC6Jik3IOxqvjSlIswM=; b=bAAhYr30J/bEtXWlCJhipWkWaZ3SkHT/1mWIgxmML4MXMGM7dGaFOfLj6YMrTtjMv1 rC8WFdPL+B2PfRSXwmBuDWIi81Kxw1uN5peChPOGvrznx7QrIVEZrAGQL5lryFjH47d/ 4Xhp0YXzPplxV42126vxlnFsONCOTLhZuGhDZebND2fTA0ifzWgkNoTSXxt7dt4H+EV7 aF6PHbhcX9DU2cRAat1lU+YOMz1QwtFyMKaco7YnAMLetDAC9xaI6mWmQsO6KkGSO87q /grJp36rXQXVCHv8AwyXu0iyH814RCurComun2dTduGbHYT452nW6vWEz0Nh3ItST8xK R5Gg== X-Forwarded-Encrypted: i=1; AJvYcCVWhH44X1dJtMNZDV2G7htLmhi7wnbAsi+Tt6n4quThfx+j3H4ps8Hbx3P7zLqKbbAeGxkTHxJjh+W5PBSg@lists.postgresql.org X-Gm-Message-State: AOJu0YwEUAXMx3X2fCPX3npbZktr9hwyuPV1tpOTSokgG7xhkg87uWgQ KoZnVHL5WdCjNmaaTgHJ+rb/bewOP2EB3STlRvumSM7M3G3gcc55psuGe+5PA7Qv4QNxqdr3YhH hYEBPkVlShVL1OfzqLfrtLFtGlnE= X-Google-Smtp-Source: AGHT+IE0malO0ayOgKhaZmVYVnIaCcGUxjr3w0CuficqKpPZ8pnaRCJ+RCvN2OTlD/ryEkwMnc/MAwEicR3S8eNTzwI= X-Received: by 2002:a05:6512:3f14:b0:535:6942:29ea with SMTP id 2adb3069b0e04-53b348bc297mr4921297e87.11.1730198556248; Tue, 29 Oct 2024 03:42:36 -0700 (PDT) MIME-Version: 1.0 References: <644FEBBB-3AFA-4848-B091-696D2132227D@skatteetaten.no> In-Reply-To: <644FEBBB-3AFA-4848-B091-696D2132227D@skatteetaten.no> From: David Rowley Date: Tue, 29 Oct 2024 23:42:24 +1300 Message-ID: Subject: Re: Max size per relation for partitioned tables To: "Reftel, Bengt Erik Magnus" Cc: "David G. Johnston" , "pgsql-general@lists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 29 Oct 2024 at 22:01, Reftel, Bengt Erik Magnus wrote: > Thank you! I=C2=B4ll try to make a change to the documentation to clarify= that. Perhaps a new row after the "relation size" row with "partitioned table" and upper limit of "32TB * number of partitions" with a comment "individual partitions cannot exceed 32TB" David