| From: | Ranier Vilela <ranier(dot)vf(at)gmail(dot)com> |
|---|---|
| To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jelte Fennema <Jelte(dot)Fennema(at)microsoft(dot)com>, "mmoncure(at)gmail(dot)com" <mmoncure(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de> |
| Subject: | Re: [PATCH] Optimize json_lex_string by batching character copying |
| Date: | 2022-08-15 18:38:59 |
| Message-ID: | CAEudQApiA058=pe-=iBZSUKX2Qy_Vc96ehkWAkdUsPykTpq+vA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Em seg., 15 de ago. de 2022 às 15:34, Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
escreveu:
> 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
>
Sorry too fast, 270,298ms with native memchr.
v5
Time: 208,689 ms
regards,
Ranier Vilela
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2022-08-15 19:25:05 | Re: Cleaning up historical portability baggage |
| Previous Message | Ranier Vilela | 2022-08-15 18:34:31 | Re: [PATCH] Optimize json_lex_string by batching character copying |