Search Postgresql Archives

Re: Design strategy for table with many attributes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux