Re: Memory exhausted errors - Mailing list pgsql-admin

From Tom Lane
Subject Re: Memory exhausted errors
Date
Msg-id 14970.996798838@sss.pgh.pa.us
Whole thread Raw
In response to Re: Memory exhausted errors  (Chris Ruprecht <chrup999@yahoo.com>)
List pgsql-admin
Chris Ruprecht <chrup999@yahoo.com> writes:
> Thank you so very much for your research! I have broken down the load
> procedure into two parts and it's looking great. The run time is sort of
> identical (about 3 minutes for today's file) but memory usage stays under 30
> MB instead of rising up to ... The old routine is busy running to compare
> and it currently sits at 344 MB - major difference (377 MB now). I see a
> very slight increase in the 'size' field (under top), about 128 KB every 4
> seconds which, maybe, could be attributed to some procedural overhead?

Residual leakage within the outer procedure's for-loop, no doubt.
As long as you can live with it until 7.2 comes out, I think you'll be
okay.

            regards, tom lane

pgsql-admin by date:

Previous
From: Chris Ruprecht
Date:
Subject: Re: Memory exhausted errors
Next
From: Steve Doerr
Date:
Subject: Modifying existing tables