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

From Craig Ringer
Subject Re: Faster methods for getting SPI results (460% improvement)
Date
Msg-id CAMsr+YGs_q-f4khX7__Z6ADML9+NyuLKcrA3npRjoZcZ7u-uCw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Faster methods for getting SPI results (460%improvement)  (Jim Nasby <jim.nasby@openscg.com>)
List pgsql-hackers
On 6 March 2017 at 05:09, Jim Nasby <jim.nasby@openscg.com> wrote:
> 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.

Taking a look at this now.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: 'Andres Freund'
Date:
Subject: Re: Statement timeout behavior in extended queries
Next
From: Michael Paquier
Date:
Subject: Re: Speedup twophase transactions