Re: [HACKERS] Memory exhaustion during bulk insert

2009-04-15 Thread Alvaro Herrera
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

Re: [HACKERS] Memory exhaustion during bulk insert

2009-04-15 Thread Tom Lane
Xin Wang writes: > I searched the mailinglist archive and noticed that a patch to improve > bulk insert performance is committed in Nov 2008. The log message said > "(the patch) keeps the current target buffer pinned and make it work > in a small ring of buffers to avoid having bulk inserts trash

[HACKERS] Memory exhaustion during bulk insert

2009-04-14 Thread Xin Wang
Hi all, I'm doing an experimental project using Postgres as the prototype. I want to store attribute values of xml type in an internal XML table which is created for every XML column. One XML node (element, attribute or text) is stored as a tuple in the XML table. While a 127MB XML document 'dblp.