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 CAFBsxsGb3Uq0iM5bukgTHcKBbmaC+7Vk2+uyyNAQYWjmnpwdzQ@mail.gmail.com
Whole thread Raw
In response to Re: WIP Patch: Add a function that returns binary JSONB as a bytea  (Andres Freund <andres@anarazel.de>)
Responses Re: WIP Patch: Add a function that returns binary JSONB as a bytea
Re: WIP Patch: Add a function that returns binary JSONB as a bytea
List pgsql-hackers
On Thu, Jun 23, 2022 at 9:06 PM Andres Freund <andres@anarazel.de> wrote:
> It looks like there's quite a bit of low hanging fruits to optimize...

Yeah, if escapes and control characters are rare, adding an SSE2 fast
path would give a boost to json_lex_string: check 16 bytes at a time
for those chars (plus the ending double-quote). We can also shave a
few percent by having pg_utf8_verifystr use SSE2 for the ascii path. I
can look into this.

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



pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: Postgres perl module namespace
Next
From: Önder Kalacı
Date:
Subject: Re: Postgres do not allow to create many tables with more than 63-symbols prefix