On Wed, Apr 9, 2014 at 9:38 AM, Andres Freund <and...@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 <and...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers