Jsonb extraction very slow - Mailing list pgsql-general

From hari.prasath
Subject Jsonb extraction very slow
Date
Msg-id 1566eab8731.10193ac585742.5467876610052746443@zohocorp.com
Whole thread Raw
Responses Re: Jsonb extraction very slow
List pgsql-general
Hi all
     I am using jsonb for storing key-value pair information(500 keys) and it was a very big data set with some 10M rows. Whenever i try to extract some keys(let say some 10 keys and its values) its really very slow.

Is this due to jsonb parsing (or) each time json will be loaded from disk to memory for 10keys(mainly if my keys are at end of 500 this is very slow).?



cheers
- Harry

pgsql-general by date:

Previous
From: Colin Morelli
Date:
Subject: Re: Logical Decoding Failover
Next
From: "hari.prasath"
Date:
Subject: Materialized view auto refresh