From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Allow multi-byte characters as escape in SIMILAR TO and SUBSTRING |
Date: | 2014-08-27 07:47:39 |
Message-ID: | 53FD8D1B.7030602@vmware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 08/27/2014 08:13 AM, Jeff Davis wrote:
> On Mon, 2014-08-25 at 17:41 +0300, Heikki Linnakangas wrote:
>> your patch seems to be about 2x-3x as slow as unpatched master. So this
>> needs some optimization. A couple of ideas:
>
> I didn't see anywhere near that kind of regression. On unpatched master,
> with your test case, I saw it stabilize to about 680ms. With
> similar-escape-1, I saw about 775ms (15% regression). Are those at all
> close to your numbers? Is there a chance you used an unoptimized build
> for one of them, or left asserts enabled?
Oh. I can't now reproduce my earlier results either, I must've messed up
something. I'm now seeing similar numbers as you.
> Attached a patch implementing the same idea though: only use the
> multibyte path if *both* the escape char and the current character from
> the pattern are multibyte.
>
> I also changed the comment to more clearly state the behavior upon which
> we're relying. I hope what I said is accurate.
s/the the/the/. Other than that, looks good to me.
- Heikki
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-08-27 08:08:11 | Re: pgbench throttling latency limit |
Previous Message | Fabien COELHO | 2014-08-27 07:32:16 | Re: postgresql latency & bgwriter not doing its job |