Postgres Pro
Downloads
Home   >   mailing lists

Re: Unicode normalization SQL functions - Mailing list pgsql-hackers

From John Naylor
Subject Re: Unicode normalization SQL functions
Date
Msg-id CACPNZCvxXeYQtgVzWu9S5fzR2chF7g9ta-s2-njVjd=Pk=n_3A@mail.gmail.com
Whole thread Raw
In response to Re: Unicode normalization SQL functions  (John Naylor <john.naylor@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Some problems of recovery conflict wait events
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: backend type in log_line_prefix?