Re: WIP Patch: Add a function that returns binary JSONB as a bytea

Поиск
Список
Период
Сортировка
От John Naylor
Тема Re: WIP Patch: Add a function that returns binary JSONB as a bytea
Дата
Msg-id CAFBsxsGb3Uq0iM5bukgTHcKBbmaC+7Vk2+uyyNAQYWjmnpwdzQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WIP Patch: Add a function that returns binary JSONB as a bytea  (Andres Freund <andres@anarazel.de>)
Ответы Re: WIP Patch: Add a function that returns binary JSONB as a bytea  (Andres Freund <andres@anarazel.de>)
Re: WIP Patch: Add a function that returns binary JSONB as a bytea  (John Naylor <john.naylor@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Postgres perl module namespace
Следующее
От: Önder Kalacı
Дата:
Сообщение: Re: Postgres do not allow to create many tables with more than 63-symbols prefix