| From: | John Naylor <john(dot)naylor(at)2ndquadrant(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Daniel Verite <daniel(at)manitou-mail(dot)org>, Andreas Karlsson <andreas(at)proxel(dot)se> |
| Subject: | Re: Unicode normalization SQL functions |
| Date: | 2020-03-27 07:16:12 |
| Message-ID: | CACPNZCvxXeYQtgVzWu9S5fzR2chF7g9ta-s2-njVjd=Pk=n_3A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I wrote:
>
> Regression tests pass, but I haven't measured performance yet.
Using a test similar to one upthread:
select count(*) from (select md5(i::text) as t from
generate_series(1,100000) as i) s where t is nfc normalized ;
I get (median of three)
v4 419ms
v5 310ms
with binary size
v4 HEAD + 33kB
v5 HEAD + 57kB
--
John Naylor https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro Horiguchi | 2020-03-27 07:30:07 | Re: backend type in log_line_prefix? |
| Previous Message | Masahiko Sawada | 2020-03-27 06:39:48 | Re: Some problems of recovery conflict wait events |