Re: Performance of JSON type in postgres

On 7/19/25 14:19, veem v wrote: On Sun, 20 Jul 2025 at 02:29, Adrian Klaver > wrote: On 7/19/25 13:39, veem v wrote: > I thought you are answered that with your tests above? At least for the Postgres end. As to the Snowflake end you will need

Re: Performance of JSON type in postgres

On Sat, Jul 19, 2025 at 5:19 PM veem v wrote: > > On Sun, 20 Jul 2025 at 02:29, Adrian Klaver > wrote: > >> On 7/19/25 13:39, veem v wrote: >> > >> >> I thought you are answered that with your tests above? At least for the >> Postgres end. As to the Snowflake end you will need to do comparable >

Re: Performance of JSON type in postgres

On Sun, 20 Jul 2025 at 02:29, Adrian Klaver wrote: > On 7/19/25 13:39, veem v wrote: > > > > I thought you are answered that with your tests above? At least for the > Postgres end. As to the Snowflake end you will need to do comparable > tests for fetching the data from Postgres and transforming

Re: Performance of JSON type in postgres

On 7/19/25 13:39, veem v wrote: Thank you. I tested below for sample data. I see loading or serialization seems a lot slower(twice as slower) in JSONB as compared to JSON. Whereas storage looks efficient in JSONB. and reading performance of nested fields are 7-8 times slower in JSON as co

Re: Performance of JSON type in postgres

On Tue, 15 Jul 2025 at 23:02, Merlin Moncure wrote: > 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' opi