Postgres Pro
Downloads
Home   >   mailing lists

Re: WIP Patch: Add a function that returns binary JSONB as a bytea - Mailing list pgsql-hackers

From John Naylor
Subject Re: WIP Patch: Add a function that returns binary JSONB as a bytea
Date
Msg-id CAFBsxsHko7yc8A-2PpjQ=2StomXF+T2jgKF=WaMFZWi8CvV7hA@mail.gmail.com
Whole thread Raw
In response to Re: WIP Patch: Add a function that returns binary JSONB as a bytea  (John Naylor <john.naylor@enterprisedb.com>)
List pgsql-hackers
Tree view 
I wrote:
> We can also shave a
> few percent by having pg_utf8_verifystr use SSE2 for the ascii path. I
> can look into this.

Here's a patch for that. If the input is mostly ascii, I'd expect that
part of the flame graph to shrink by 40-50% and give a small boost
overall.

-- 
John Naylor
EDB: http://www.enterprisedb.com
Attachment

pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Making the subquery alias optional in the FROM clause
Next
From: Michael Paquier
Date:
Subject: Comments referring to pg_start/stop_backup