Re: Stalled post to pgsql-general - Mailing list pgsql-general

From K D
Subject Re: Stalled post to pgsql-general
Date
Msg-id 7c69a9640903021042s345c434fsd7d9b15bedc62706@mail.gmail.com
Whole thread Raw
In response to Stalled post to pgsql-general  (Fernando Schapachnik <fpscha@ns1.via-net-works.net.ar>)
List pgsql-general
will post to proper group, sorry

On Mon, Mar 2, 2009 at 8:10 AM, <pgsql-general-owner@postgresql.org> wrote:
Your message to pgsql-general has been delayed, and requires the approval
of the moderators, for the following reason(s):

The author (K D <keithdutton@gmail.com>)
 is not a member of any of the restrict_post groups.

If you do not wish the message to be posted, or have other concerns,
please send a message to the list owners at the following address:
 pgsql-general-owner@postgresql.org


---------- Forwarded message ----------
From: K D <keithdutton@gmail.com>
To: pgsql-general@postgresql.org
Date: Mon, 2 Mar 2009 08:10:20 -0800
Subject: plpython large result set
Hello,

I am hoping to use plpython to perform various transforms on query results of very large size.

The documentation in the official 8.3 manual makes it appear as if the results of plpy.execute are read in at once (e.g., they appear to have random access and are mutable) rather than in the hidden cursor fashion of looping through a PgSql query result set.  If this correct?  If so does it mean that I need to avoid plpy.execute for very large queries?  If so, a cursor/generator interface would seem to be a substantial improvement for the future.

If I cannot use plpy.execute, is there some way to declare and use a standard cursor from within plpython?  I can find nothing on this on the web, and my own experimentation has been fruitless.  Any quick example would be hugely appreciated.

If none of the above works, my fallback will be to execute the query in PgSql, then within the fetch loop call a plpython procedure.  This works as far as my testing has gone, but seems unfortunate.

Thanks,

Kevin


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Detemine database size on Postgres 8.0
Next
From: Raymond O'Donnell
Date:
Subject: plpgsql: UPDATE...Returning in FOR loop