| From: | Jeremy Kerr <jk(at)ozlabs(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jeremy Kerr <jk(at)ozlabs(dot)org>, "<pgsql-hackers(at)postgresql(dot)org>" <pgsql-hackers(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> |
| Subject: | Re: [PATCH] backend: compare word-at-a-time in bcTruelen |
| Date: | 2009-06-17 09:31:06 |
| Message-ID: | 200906171731.07149.jk@ozlabs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
> Speaking of which, what about some performance numbers?
OK, benchmarks done:
http://ozlabs.org/~jk/projects/db/data/postgres.bcTruelen/
Summary: small increase in performance (~1-2% on my machine), at about
1.5 standard deviations from the mean. Profiles show a decent drop in
hits within bcTruelen.
However: Sysbench seems to be quite heavy with the fixed-width char
types, so may end up calling bcTruelen more than most workloads. Would
be nice to get some x86 numbers too, but I don't have a suitable machine
here.
So: The increase in performance is positive on this workload, albeit
fairly minor. Downside is increased code complexity.
Will re-send the patch once I work out how to get git to create a
context diff...
Cheers,
Jeremy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Golub | 2009-06-17 09:31:11 | Named transaction |
| Previous Message | Petr Jelinek | 2009-06-17 08:29:10 | Re: GRANT ON ALL IN schema |