On Tue, Oct 12, 2021 at 1:43 AM Simon Riggs <[email protected]> wrote:
> On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya > <[email protected]> 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.
