Re: Max size per relation for partitioned tables

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Reftel, Bengt Erik Magnus" <Magnus(dot)Reftel(at)skatteetaten(dot)no>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Max size per relation for partitioned tables
Date: 2024-10-23 21:48:18
Message-ID: CAKFQuwaXxxx_gXPB5qseEbj7a73jf_9cu54WdVdiq1etWUVdJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, October 23, 2024, Reftel, Bengt Erik Magnus <
Magnus(dot)Reftel(at)skatteetaten(dot)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´s not clear to me whether “relation” 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 know which it is?
>
> Each physical partition.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Hartman 2024-10-23 23:59:26 Re: Backup
Previous Message Adrian Klaver 2024-10-23 19:47:01 Re: Backup