| From: | Jim Nasby <jim(dot)nasby(at)openscg(dot)com> |
|---|---|
| To: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Joe Conway <mail(at)joeconway(dot)com> |
| Subject: | Re: Faster methods for getting SPI results (460% improvement) |
| Date: | 2017-03-05 21:09:44 |
| Message-ID: | c70c99a6-c5bd-e898-578f-d87af666b3a8@openscg.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2/28/17 9:42 PM, Jim Nasby wrote:
>>
>> I'll post a plpython patch that doesn't add the output format control.
>
> I've attached the results of that. Unfortunately the speed improvement
> is only 27% at this point (with 9999999 tuples). Presumably that's
> because it's constructing a brand new dictionary from scratch for each
> tuple.
I found a couple bugs. New patches attached.
--
Jim Nasby, Chief Data Architect, OpenSCG
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Add-SPI_execute_callback-and-callback-based-DestRece.patch | text/plain | 8.7 KB |
| 0002-Modify-plpython-to-use-SPI-callbacks.patch | text/plain | 13.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2017-03-05 21:10:45 | Re: objsubid vs subobjid |
| Previous Message | Jim Nasby | 2017-03-05 21:07:07 | Re: Faster methods for getting SPI results |