From: | "Chris Ruprecht" <chrup999(at)yahoo(dot)com> |
---|---|
To: | "pgadmin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Memory exhausted errors |
Date: | 2001-08-01 14:11:19 |
Message-ID: | 002301c11a93$d631ff00$5dd26383@corp.compucom.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
on a daily basis, I load records from an external source into my database. During the load, the records go through a validation process during which I have to read anywhere between 2 and 15 records from the database.
The postmaster process which does this, starts out with 10 MB memory usage but soon swells up to about 500 MB (on a normal day). Some days, I receive a larger amount of data and the process swells up to about 1.4 GB before it bombs out with a 'memory exhausted' message.
I believe, the answer is to have the transactions smaller, but since PL/PGSQL runs everything is one big transaction, how would I go about that? Can I temporarily disable transaction processing all together for this process? (if the load fails, I can easily delete the created records by hand).
Best regards,
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-01 14:35:05 | Re: Memory exhausted errors |
Previous Message | Selvam | 2001-07-31 23:33:40 | Re: Problem starting postgresql |