Postgres Pro
Downloads
Home   >   mailing lists

Re: Large data sets and FOR LOOP's - Mailing list pgsql-sql

From Tom Lane
Subject Re: Large data sets and FOR LOOP's
Date
Msg-id 8568.1016032094@sss.pgh.pa.us
Whole thread Raw
In response to Large data sets and FOR LOOP's  (Bo Lorentsen <bl@netgroup.dk>)
Responses Re: Large data sets and FOR LOOP's  (Bo Lorentsen <bl@netgroup.dk>)
List pgsql-sql
Tree view 
Bo Lorentsen <bl@netgroup.dk> writes:
> But, if I, in my code, make "for loop" on a huge select result (about
> 1.7 mil. rows), my function begin to consume alot of memory.

What PG version?

We fixed quite a few transient-memory-leak problems in plpgsql in 7.2.
        regards, tom lane

pgsql-sql by date:

Previous
From: Andre Schubert
Date:
Subject: REFERENCES
Next
From: Charles Hauser
Date:
Subject: ALTER CONSTRAINT FOREIGN KEY