Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Faster methods for getting SPI results (460%improvement) - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: [HACKERS] Faster methods for getting SPI results (460%improvement)
Date
Msg-id c70c99a6-c5bd-e898-578f-d87af666b3a8@openscg.com
Whole thread Raw
In response to Re: [HACKERS] Faster methods for getting SPI results (460%improvement)  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Faster methods for getting SPI results (460% improvement)  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Attachment

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [HACKERS] Faster methods for getting SPI results
Next
From: Jim Nasby
Date:
Subject: Re: [HACKERS] objsubid vs subobjid