Re: Performance of JSON type in postgres

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Performance of JSON type in postgres
Дата
Msg-id CAKFQuwarbmz7=yg14h6u-UhGPfbT56TsX8S6w9wVdMHGiWxbYg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance of JSON type in postgres  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Performance of JSON type in postgres
Список pgsql-general
Дерево обсуждения
On Mon, Jul 14, 2025 at 12:54 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 7/14/25 12:51, veem v wrote:
> So I want to
> understand the experts' opinion on this which I believe will  be
> crucial during design itself.

It is spelled out here:

https://www.postgresql.org/docs/current/datatype-json.html


I've taken to heart the main takeaway from that page:

"In general, most applications should prefer to store JSON data as jsonb, unless there are quite specialized needs, such as legacy assumptions about ordering of object keys."

David J.

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