MIME-Version: 1.0
References: <CAKna9VbQ=o2Yhjo1EitaxzYpWAXe9vw6QtamzCsNNp2-rQOFSA@mail.gmail.com>
 <CAKFQuwYpai5snt5mEgyXK4m6nR5T6sP-YTYH-GQ0Hs2rXS7uLA@mail.gmail.com>
 <CAKna9VZdihb=n9mNGaCZLKYbWAoS0+knfi_PAfLC5w=Mj5Egig@mail.gmail.com>
 <D4CAF64D-2F47-470B-9F14-860FFD7FD2E7@gmail.com> <CAKna9VaNKPR9XruS-yz0qLLgAyik6L-_kGX=C8B682wRSmnn=A@mail.gmail.com>
 <A306FFC9-1D69-4C3F-8B4D-F0983D9E9C33@gmail.com> <CAKna9VYXKu-1KpV_1X3Jz0iNZ+Uf4WGwYRm62tCQvyp4-L0WCw@mail.gmail.com>
 <CAApHDvp6FJW0MnchEfis=2ANUTNu4CHVQOcs95=NwTg4SQrxtQ@mail.gmail.com> <CAKna9Vah53TtUX9qYpDz0hPoAFSLUBqtzriWU=xy8vCWQU+Leg@mail.gmail.com>
In-Reply-To: <CAKna9Vah53TtUX9qYpDz0hPoAFSLUBqtzriWU=xy8vCWQU+Leg@mail.gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
Date: Fri, 5 Jul 2024 20:58:35 +1200
Message-ID: <CAApHDvqK+Ji5syVZoThQvKKAtWt=cO14Mf7NwWwrHbPoPMqWfA@mail.gmail.com>
Subject: Re: Design strategy for table with many attributes
To: Lok P <loknath.73@gmail.com>
Cc: Guyren Howe <guyren@gmail.com>, pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: <https://www.postgresql.org/message-id/CAApHDvqK%2BJi5syVZoThQvKKAtWt%3DcO14Mf7NwWwrHbPoPMqWfA%40mail.gmail.com>
Precedence: bulk

On Fri, 5 Jul 2024 at 20:53, Lok P <loknath.73@gmail.com> wrote:
> However out of curiosity, if the roasted/compressed component or column which is JSON itself goes beyond 8k post compression, will it break then?

No. The size limit of a varlena field such as TEXT, JSON or JSONB is
1GB.  See "field size" in [1].

Please also read [2].

David

[1] https://www.postgresql.org/docs/current/limits.html
[2] https://www.postgresql.org/docs/current/storage-toast.html