On Fri, 5 Jul 2024 at 20:53, Lok P <loknath(dot)73(at)gmail(dot)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