On Tue, Oct 12, 2021 at 1:43 AM Simon Riggs <simon.ri...@enterprisedb.com> wrote:
> On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya > <ram.mau...@lavainternational.in> wrote: > > > Confirm what is Avg/max size of these JSON docs in Postgres. > > JSON and JSONB datatypes can both be max 1GB in size. > That is per row. Just to confirm- The compression associated with TOAST is only if the value can fit in line, right? Columns don't get stored out-of-line in a toast table as a compressed value as I read the documentation. I suppose that would make reads a bit crazy.
