Postgres Pro
Downloads
Home   >   mailing lists

Re: Design strategy for table with many attributes - Mailing list pgsql-general

From David Rowley
Subject Re: Design strategy for table with many attributes
Date
Msg-id CAApHDvqK+Ji5syVZoThQvKKAtWt=cO14Mf7NwWwrHbPoPMqWfA@mail.gmail.com
Whole thread Raw
In response to Re: Design strategy for table with many attributes  (Lok P <loknath.73@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Lok P
Date:
Subject: Re: Design strategy for table with many attributes
Next
From: sud
Date:
Subject: Load a csv or a avro?