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

From Reftel, Bengt Erik Magnus
Subject Re: Max size per relation for partitioned tables
Date
Msg-id 644FEBBB-3AFA-4848-B091-696D2132227D@skatteetaten.no
Whole thread Raw
In response to Re: Max size per relation for partitioned tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Max size per relation for partitioned tables
List pgsql-general
Wednesday, 23 October 2024 at 23:48, David G. Johnston <david.g.johnston@gmail.com> wrote:
> On Wednesday, October 23, 2024, Reftel, Bengt Erik Magnus <mailto: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.

Thank you! I´ll try to make a change to the documentation to clarify that.

Best Regards
Magnus Reftel


________________________________
Denne e-posten og eventuelle vedlegg er beregnet utelukkende for den institusjon eller person den er rettet til og kan
værebelagt med lovbestemt taushetsplikt. 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
confidentialinformation and may be legally protected from disclosure. If you are not the intended recipient of this
message,please immediately delete the message and alert the Norwegian Tax Administration.
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Setting "ucs_basic" as the default database collation
Next
From: 馬 騰飛
Date:
Subject: RE: Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3