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 |