Re: Performance of JSON type in postgres

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: veem v <veema0000(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Performance of JSON type in postgres
Date: 2025-07-14 20:00:54
Message-ID: CAKFQuwarbmz7=yg14h6u-UhGPfbT56TsX8S6w9wVdMHGiWxbYg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 14, 2025 at 12:54 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-07-14 20:07:53 Re: Syntax error needs explanation
Previous Message Rich Shepard 2025-07-14 19:59:02 Re: Syntax error needs explanation