public inbox for [email protected]
help / color / mirror / Atom feedPerformance of JSON type in postgres
2+ messages / 2 participants
[nested] [flat]
* Performance of JSON type in postgres
@ 2025-07-14 19:51 veem v <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: veem v @ 2025-07-14 19:51 UTC (permalink / raw)
To: pgsql-general <[email protected]>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Performance of JSON type in postgres
@ 2025-07-14 19:54 Adrian Klaver <[email protected]>
parent: veem v <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Adrian Klaver @ 2025-07-14 19:54 UTC (permalink / raw)
To: veem v <[email protected]>; pgsql-general <[email protected]>
On 7/14/25 12:51, veem v wrote:
> 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.
It is spelled out here:
https://www.postgresql.org/docs/current/datatype-json.html
>
> Regards
> Veem
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-07-14 19:54 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-07-14 19:51 Performance of JSON type in postgres veem v <[email protected]>
2025-07-14 19:54 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox