On Wed, Apr 9, 2014 at 9:38 AM, Andres Freund <andres@2ndquadrant.com> wrote:
> On 2014-04-09 09:17:59 -0400, Robert Haas wrote:
>> On Wed, Apr 9, 2014 at 8:32 AM, Andres Freund <andres@2ndquadrant.com> wrote:
>> > I've tried to reproduce problems around this (when I wrote this), but
>> > it's really hard to construct cases that need more than 8 pins. I've
>> > tested performance for those cases by simply not using the array, and
>> > while the performance suffers a bit, it's not that bad.
>>
>> Suspended queries won't do it?
>
> What exactly do you mean by "suspended" queries? Defined and started
> portals? Recursive query execution?
Open a cursor and fetch from it; leave it open while doing other things.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company