Re: [PATCH] Optimize json_lex_string by batching character copying

Поиск
Список
Период
Сортировка
От Ranier Vilela
Тема Re: [PATCH] Optimize json_lex_string by batching character copying
Дата
Msg-id CAEudQArNtiFgrMbmmw7k+0JfoROE4a0fv7HL8_7oG3Wu0-Kw4Q@mail.gmail.com
обсуждение исходный текст
Ответ на [PATCH] Optimize json_lex_string by batching character copying  (Jelte Fennema <Jelte.Fennema@microsoft.com>)
Ответы Re: [PATCH] Optimize json_lex_string by batching character copying
Список pgsql-hackers

Hi,

I ran this test.

DROP TABLE IF EXISTS long_json_as_text;
CREATE TABLE long_json_as_text AS
with long as (
select repeat(description, 11)
from pg_description
)
select (select json_agg(row_to_json(long))::text as t from long) from
generate_series(1, 100);
VACUUM FREEZE long_json_as_text;

select 1 from long_json_as_text where t::json is null;

head:
Time: 161,741ms

v5:
Time: 270,298 ms

ubuntu 64 bits
gcc 9.4.0

Am I missing something?

regards,
Ranier Vilela

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: build remaining Flex files standalone
Следующее
От: Ranier Vilela
Дата:
Сообщение: Re: [PATCH] Optimize json_lex_string by batching character copying