Postgres Pro
Downloads
Home   >   mailing lists

Re: Log full with gigabyes of CurTransactionContex - Mailing list pgsql-admin

From Tom Lane
Subject Re: Log full with gigabyes of CurTransactionContex
Date
Msg-id 16564.1245079425@sss.pgh.pa.us
Whole thread Raw
In response to Re: Log full with gigabyes of CurTransactionContex  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
Responses Re: Log full with gigabyes of CurTransactionContex  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
List pgsql-admin
Tree view 
=?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com> 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

pgsql-admin by date:

Previous
From: Iñigo Martinez Lasala
Date:
Subject: Re: Log full with gigabyes of CurTransactionContex
Next
From: Gurjeet Singh
Date:
Subject: Re: Log full with gigabyes of CurTransactionContex