public inbox for [email protected]  

help / color / mirror / Atom feed

Re: Max size per relation for partitioned tables
2+ messages / 2 participants
[nested] [flat]

* Re: Max size per relation for partitioned tables
@ 2024-10-28 09:41  Reftel, Bengt Erik Magnus <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Reftel, Bengt Erik Magnus @ 2024-10-28 09:41 UTC (permalink / raw)
  To: David G. Johnston <[email protected]>; +Cc: [email protected] <[email protected]>

Wednesday, 23 October 2024 at 23:48, David G. Johnston <[email protected]> wrote:
> On Wednesday, October 23, 2024, Reftel, Bengt Erik Magnus <mailto:[email protected]> 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ære belagt 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 confidential information 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.


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Max size per relation for partitioned tables
@ 2024-10-29 10:42  David Rowley <[email protected]>
  parent: Reftel, Bengt Erik Magnus <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: David Rowley @ 2024-10-29 10:42 UTC (permalink / raw)
  To: Reftel, Bengt Erik Magnus <[email protected]>; +Cc: David G. Johnston <[email protected]>; [email protected] <[email protected]>

On Tue, 29 Oct 2024 at 22:01, Reftel, Bengt Erik Magnus
<[email protected]> wrote:
> Thank you! I´ll 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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-10-29 10:42 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-28 09:41 Re: Max size per relation for partitioned tables Reftel, Bengt Erik Magnus <[email protected]>
2024-10-29 10:42 ` David Rowley <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox