Re: Jsonb extraction very slow - Mailing list pgsql-general

From hari.prasath
Subject Re: Jsonb extraction very slow
Date
Msg-id 1567d050e6e.c23a53313551.8323271350561778673@zohocorp.com
Whole thread Raw
In response to Re: Jsonb extraction very slow  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>What were you doing to "get ten keys out"? If those were ten separate 
>JSON operators, they'd likely have done ten separate decompressions. 
>You'd have saved something by having the TOAST data already fetched into 
>shared buffers, but it'd still hardly be free. 

Now i got the point. Initially, i thought for n keys to extract from json only one time the full json is decompressed. But it's actually decompressing n times for n keys.


Thanks
- Harry

pgsql-general by date:

Previous
From: "Yelai, Ramkumar"
Date:
Subject: pgbasebackup is failing after truncate
Next
From: James Sewell
Date:
Subject: Standby crash