Re: Large data sets and FOR LOOP's

Bo Lorentsen wrote:
> 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 ?
   Sure,  if they whould've been available in PL/pgSQL. This all   was a  combined  feature  enhancement  for  7.2.
1st cursor   support  over  SPI  (an  internal  query interface inside the   backend), 2nd support for cursors and
reference cursors  in   PL/pgSQL,  3rd  automatic  usage  of  internal cursors in FOR   loops.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com