Received: from secure.webhotel.net (secure.webhotel.net [195.41.202.80]) by postgresql.org (Postfix) with SMTP id 7346C475902 for ; Thu, 14 Mar 2002 02:57:52 -0500 (EST) Received: (qmail 69156961 invoked from network); 14 Mar 2002 08:02:29 -0000 Received: from unknown (HELO localhost.localdomain) (217.157.135.140) by mail.webhotel.net with SMTP; 14 Mar 2002 08:02:29 -0000 Subject: Re: Large data sets and FOR LOOP's From: Bo Lorentsen To: Jan Wieck Cc: pgsql-sql In-Reply-To: <200203131629.g2DGTRp31887@saturn.janwieck.net> References: <200203131629.g2DGTRp31887@saturn.janwieck.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.2 Date: 14 Mar 2002 08:57:52 +0100 Message-Id: <1016092672.878.14.camel@netgroup> Mime-Version: 1.0 X-Archive-Number: 200203/179 X-Sequence-Number: 7059 On Wed, 2002-03-13 at 17:29, Jan Wieck wrote: > You probably want to upgrade to 7.2, because 7.2's PL/pgSQL > uses the newly available SPI cursors silently in FOR loops. This sounds good, I like to upgrade anyway, also to take advantage of the new vaccum. > Releases before 7.2 loaded the entire result set into memory > (ahem, swap space) before entering the FOR loop. This was what I guested, too :-) Would a cursor have helped any ? /BL