Re: Avg/max size of these JSON docs in Postgres

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Avg/max size of these JSON docs in Postgres
Дата
Msg-id CAHOFxGobn9REnhU0dd=yRvPQ5a_qj97GRr1vxCOdafOfUTjd+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Avg/max size of these JSON docs in Postgres  (Simon Riggs <simon.riggs@enterprisedb.com>)
Ответы Re: Avg/max size of these JSON docs in Postgres
Re: Avg/max size of these JSON docs in Postgres
Список pgsql-general
On Tue, Oct 12, 2021 at 1:43 AM Simon Riggs <simon.riggs@enterprisedb.com> wrote:
On Tue, 12 Oct 2021 at 08:14, Ram Pratap Maurya
<ram.maurya@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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Aw: Re: Fault with initcap
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Avg/max size of these JSON docs in Postgres