Re: Performance of JSON type in postgres

2025-07-15 Thread Merlin Moncure
On Mon, Jul 14, 2025 at 2:01 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Jul 14, 2025 at 12:54 PM Adrian Klaver > 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

Re: Performance of JSON type in postgres

2025-07-14 Thread David G. Johnston
On Mon, Jul 14, 2025 at 12:54 PM Adrian Klaver 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.htm

Re: Performance of JSON type in postgres

2025-07-14 Thread Adrian Klaver
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 wan