Jsonb extraction very slow

From: "hari(dot)prasath" <hari(dot)prasath(at)zohocorp(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Jsonb extraction very slow
Date: 2016-08-09 09:39:10
Message-ID: 1566eab8731.10193ac585742.5467876610052746443@zohocorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hari.prasath 2016-08-09 09:50:08 Materialized view auto refresh
Previous Message Colin Morelli 2016-08-09 02:58:17 Re: Logical Decoding Failover