Re: Supporting SJIS as a database encoding - Mailing list pgsql-hackers

From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Kyotaro
> HORIGUCHI
> <Using radix tree>
> $ time psql postgres -c 'select t.a from t, generate_series(0, 9999)' >
> /dev/null
> 
> real    0m22.696s
> user    0m16.991s
> sys    0m0.182s>
> 
> Using binsearch the result for the same operation was
> real    0m35.296s
> user    0m17.166s
> sys    0m0.216s
> 
> Returning in UTF-8 bloats the result string by about 1.5 times so it doesn't
> seem to make sense comparing with it. But it takes real = 47.35s.

Cool, 36% speedup!  Does this difference vary depending on the actual characters used, e.g. the speedup would be
greaterif most of the characters are ASCII?
 

Regards
Takayuki Tsunakawa