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 55F05DD9.40706@sigaev.ru
Whole thread Raw
In response to Re: jsonb value retrieval performance  (Tom Smith <tomsmith1989sk@gmail.com>)
List pgsql-general
Tree view 
>   does it read in the whole jsonb tree structure in memory
> and get to v1  or it has some optimization so only get v1 instead
> of reading in the whole structure.

it reads, untoasts and uncompresses whole value and then executes search. An
idea to fix that is a reading jsonb value by only needed chunks.


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

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: log_statement = 'mod' does not log all data modifying statements
Next
From: Melvin Davidson
Date:
Subject: clone_schema function