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 1DD10C2A-BF36-4D01-A9AC-99BD95394EB0@openscg.com
Whole thread Raw
In response to Re: [HACKERS] Faster methods for getting SPI results (460%improvement)  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Apr 6, 2017, at 9:10 PM, Andres Freund <andres@anarazel.de> wrote:
>
>>> Why?  We could very well return a somewhat "smarter" object. Returning
>>> rows row-by-row if accessed via iterator, materializes when accessed via
>>> row offset.
>>
>> I completely agree with that. What I don't understand is the objection to
>> speeding up the old access method. Or are you thinking we'd just abandon the
>> old method?
>
> What I'm saying is that we can do that transparently, with the current
> API.  And there's no need to materialize anything in plpython, we can
> transparently use the SPI materialized version.

Oh, just switching from a list to an iterator. Ok, I finally get it.


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] Faster methods for getting SPI results (460%improvement)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Faster methods for getting SPI results (460% improvement)