Try
Home   >   mailing lists

Re: Performance of JSON type in postgres - Mailing list pgsql-general

From David G. Johnston
Subject Re: Performance of JSON type in postgres
Date
Msg-id CAKFQuwarbmz7=yg14h6u-UhGPfbT56TsX8S6w9wVdMHGiWxbYg@mail.gmail.com
Whole thread Raw
In response to Re: Performance of JSON type in postgres  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Performance of JSON type in postgres
List pgsql-general
Tree view
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 by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Syntax error needs explanation
Next
From: "David G. Johnston"
Date:
Subject: Re: Syntax error needs explanation