Re: Memory exhaustion during bulk insert

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Xin Wang <andywx(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Memory exhaustion during bulk insert
Date: 2009-04-15 16:57:53
Message-ID: 20090415165753.GG7709@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Xin Wang escribió:

> However, I do not know much about the code below the heapam layer. Can that
> patch solve my problem (the version I use is 8.3.5)? Or could you give me
> some suggestion about how to avoid memory exhaustion during bulk insert
> (in the meanwhile it must clean up nicely after a transaction abort)?

Try 8.3.7. There have been memory leak fixes in XML code lately, which
maybe solve your problem.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-04-15 17:23:35 Re: Unicode string literals versus the world
Previous Message Alvaro Herrera 2009-04-15 16:55:51 missing translation marker