On Tue, Oct 12, 2021 at 1:43 AM Simon Riggs <simon.riggs@xxxxxxxxxxxxxxxx> wrote:
On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya
<ram.maurya@xxxxxxxxxxxxxxxxxxxx> 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.
