Performance of JSON type in postgres

From: veem v <veema0000(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Performance of JSON type in postgres
Date: 2025-07-14 19:51:38
Message-ID: CAB+=1TU2bi8UkdD94kMizsTrTBUgqbdWKtM4Lq67+BMi6Vt1qA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
It's postgres 15+. And need guidance on JSON types, (for both on premise
vanilla postgres installation and AWS cloud based RDS/aurora postgres
installations).

I have never worked on a JSON data type in the past. But now in one of the
scenarios the team wants to use it and thus want to understand if there are
any pros/cons in using JSONB vs JSON in postgres. Is there a specific
scenario in which one should use one vs other. Any storage or performance
threshold or limitations if any exists etc? Even some team mates suggest
storing it simply in string data types. So I want to understand the
experts' opinion on this which I believe will be crucial during design
itself.

Regards
Veem

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-07-14 19:54:49 Re: Performance of JSON type in postgres
Previous Message Adrian Klaver 2025-07-14 19:45:45 Re: Syntax error needs explanation