| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Inlining of couple of functions in pl_exec.c improves performance |
| Date: | 2020-07-03 19:49:37 |
| Message-ID: | 1046810.1593805777@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I did some performance testing on 0001+0002 here, and found that
for me, there's basically no change on x86_64 but a win of 2 to 3
percent on aarch64, using Pavel's pi_est_1() as a representative
case for simple plpgsql statements. That squares with your original
results I believe. It's not clear to me whether any of the later
tests in this thread measured these changes in isolation, or only
with 0003 added.
Anyway, that's good enough for me, so I pushed 0001+0002 after a
little bit of additional cosmetic tweaking.
I attach your original 0003 here (it still applies, with some line
offsets). That's just so the cfbot doesn't get confused about what
it's supposed to test now.
regards, tom lane
| Attachment | Content-Type | Size |
|---|---|---|
| 0003-Inline-exec_cast_value.patch | text/x-diff | 3.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2020-07-03 19:50:02 | Re: Default setting for enable_hashagg_disk (hash_mem) |
| Previous Message | Pavel Stehule | 2020-07-03 19:19:20 | Re: pro pametniky -historie vzniku PL/SQL |