Postgres Pro
Downloads
Home   >   mailing lists

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

From Gurjeet Singh
Subject Re: Log full with gigabyes of CurTransactionContex
Date
Msg-id 65937bea0906150818rc87cfc7s79af7ef1a1f16619@mail.gmail.com
Whole thread Raw
In response to Re: Log full with gigabyes of CurTransactionContex  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
List pgsql-admin
Tree view
On Mon, Jun 15, 2009 at 8:42 PM, Iñigo Martinez Lasala <imartinez@vectorsf.com> wrote:
Thank you very much, Tom.

We have increased shared buffers to 2.5GB (linux kernels allows us reach this level) and lowered work_mem to 500MB.
Let's see tonight. :-)


If you want to increase shared buffers beyond this value, you should look at increasing shmmax in sysctl.conf.

Best regards,
--
Lets call it Postgres

EnterpriseDB      http://www.enterprisedb.com

gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
Mail sent from my BlackLaptop device

pgsql-admin by date:

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