On Fri, 5 Jul 2024 at 20:53, Lok P <loknath...@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
