Postgres Pro
Downloads
Home   >   mailing lists

Re: jsonb value retrieval performance - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: jsonb value retrieval performance
Date
Msg-id 55EF13FA.1060809@sigaev.ru
Whole thread Raw
In response to Re: jsonb value retrieval performance  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-general
Tree view 
> Suppose, most time is spent for decompressing huge value, not for actual search
> inside jsonb. If so, we need to implement some search method which decompress
> some chunks of jsonb.
On artificial example:
%SAMP IMAGE      FUNCTION             CALLERS
  92.9 postgres   pglz_decompress      toast_decompress_datum


--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: jsonb value retrieval performance
Next
From: Merlin Moncure
Date:
Subject: Re: LATERAL query extreme slow due to partition