From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Chris Ruprecht <chrup999(at)yahoo(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Memory exhausted errors |
Date: | 2001-08-03 00:33:58 |
Message-ID: | 14970.996798838@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Chris Ruprecht <chrup999(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Doerr | 2001-08-03 03:37:37 | Modifying existing tables |
Previous Message | Chris Ruprecht | 2001-08-03 00:20:24 | Re: Memory exhausted errors |