Re: jsonb access operators inefficiency

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: obartunov(at)gmail(dot)com
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: jsonb access operators inefficiency
Date: 2014-05-30 17:39:17
Message-ID: 5388C245.90306@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 05/30/2014 01:30 PM, Oleg Bartunov wrote:
> The patch really improves access performance to jsonb. On the
> delicious bookmarks I got 5 times better performance.Now jsonb
> outperforms json on simple access (slide 12 of pgcon presentation) by
> 103 times !
>
>

(Oleg, please try not to top-post)

The question is whether the speedup comes from the reduction in lookup
times or the reduction in string copying. I have a strong suspicion that
it's mostly the first, not the second.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-05-30 17:41:56 Re: jsonb access operators inefficiency
Previous Message Oleg Bartunov 2014-05-30 17:30:05 Re: jsonb access operators inefficiency