Doc limitation update proposal: include out-of-line OID usage per TOAST-ed columns

From: Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Doc limitation update proposal: include out-of-line OID usage per TOAST-ed columns
Date: 2023-04-21 06:39:10
Message-ID: CAKZiRmwWhp2yxjqJLwbBjHdfbJBcUmmKMNAZyBjjtpgM9AMatQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi -hackers,

I would like to ask if it wouldn't be good idea to copy the
https://wiki.postgresql.org/wiki/TOAST#Total_table_size_limit
discussion (out-of-line OID usage per TOAST-ed columns / potential
limitation) to the official "Appendix K. PostgreSQL Limits" with also
little bonus mentioning the "still searching for an unused OID in
relation" notice. Although it is pretty obvious information for some
and from commit 7fbcee1b2d5f1012c67942126881bd492e95077e and the
discussion in [1], I wonder if the information shouldn't be a little
more well known via the limitation (especially to steer people away
from designing very wide non-partitioned tables).

Regards,
-J.

[1] - https://www.postgresql.org/message-id/flat/16722-93043fb459a41073%40postgresql.org

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2023-04-21 06:50:34 Re: optimize several list functions with SIMD intrinsics
Previous Message Gurjeet Singh 2023-04-21 06:38:25 Re: Reorder connection markers in libpq TAP tests