From: Frank Joerdens <frank@joerdens.de>
To: Laurent Laborde <kerdezixe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Full statement logging problematic on larger machines?
Date: Fri, 20 Mar 2009 19:01:05 +0000
Message-ID: <7d10d2df0903201201x470bdbb9gfdee702a4157f31b@mail.gmail.com> (raw)
In-Reply-To: <8a1bfe660903121432k153f7c8u3f86c1ae4b7f1551@mail.gmail.com>
References: <7d10d2df0903111227g2e40e742g5992cba5158dd4d2@mail.gmail.com>
<3401.1236804370@sss.pgh.pa.us>
<7d10d2df0903111542o53abb3dbvfc405a597e4c9fa8@mail.gmail.com>
<8a1bfe660903121432k153f7c8u3f86c1ae4b7f1551@mail.gmail.com>
On Thu, Mar 12, 2009 at 9:32 PM, Laurent Laborde <kerdezixe@gmail.com> wrote:
> On Wed, Mar 11, 2009 at 11:42 PM, Frank Joerdens <frank@joerdens.de> wrote:
>>
>> effective_cache_size = 4GB
>
> Only 4GB with 64GB of ram ?
I'd been overly cautious lately with config changes as it's been
difficult to argue for downtime and associated service risk. Changed
it to 48 GB now since it doesn't require a restart which I'd missed.
Thanks for spotting!
Regards,
Frank
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: frank@joerdens.de, kerdezixe@gmail.com
Subject: Re: Full statement logging problematic on larger machines?
In-Reply-To: <7d10d2df0903201201x470bdbb9gfdee702a4157f31b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox