In parallel we have changed the procedure in order to process insert queries in smaller chunks. In our preproduction environment has solved the problem.
-----Original Message-----
From: Tom Lane <tgl@xxxxxxxxxxxxx>
To: Iñigo Martinez Lasala <imartinez@xxxxxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: Log full with gigabyes of CurTransactionContex
Date: Mon, 15 Jun 2009 11:23:45 -0400
=?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@xxxxxxxxxxxx> writes: > We have increased shared buffers to 2.5GB (linux kernels allows us reach > this level) and lowered work_mem to 500MB. You are apparently unclear on the concept. Pushing the database to the limit of the available address space is probably going to result in failures. Redistributing a set of overoptimistic parameters into a different set of overoptimistic parameters will not fix this. regards, tom lane
