Re: Max size per relation for partitioned tables - Mailing list pgsql-general

From David G. Johnston
Subject Re: Max size per relation for partitioned tables
Date
Msg-id CAKFQuwaXxxx_gXPB5qseEbj7a73jf_9cu54WdVdiq1etWUVdJg@mail.gmail.com
Whole thread Raw
In response to Max size per relation for partitioned tables  ("Reftel, Bengt Erik Magnus" <Magnus.Reftel@skatteetaten.no>)
Responses Re: Max size per relation for partitioned tables
List pgsql-general
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´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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Backup
Next
From: Andy Hartman
Date:
Subject: Re: Backup