Frank jansen wrote:
> Now with 8.4.3 the scripts work, but only until it has eaten up my
> memory (4 gig).
> The function above is executed for ~40000 items, with iteration
> steps of 300 items, every step memery consumption is increasing till
> the machine hangs and process dies.
Can you describe more fully what you're doing here? (hopefully with
schema details, sample data and queries) Perhaps there's a memory leak
that needs to be plugged.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support