Skip site navigation (1) Skip section navigation (2)

Re: Full statement logging problematic on larger machines?

From: Frank Joerdens <frank(at)joerdens(dot)de>
To: Laurent Laborde <kerdezixe(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Full statement logging problematic on larger machines?
Date: 2009-03-20 19:01:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Thu, Mar 12, 2009 at 9:32 PM, Laurent Laborde <kerdezixe(at)gmail(dot)com> wrote:
> On Wed, Mar 11, 2009 at 11:42 PM, Frank Joerdens <frank(at)joerdens(dot)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!



In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2009-03-20 19:04:57
Subject: Re: Need help with one query
Previous:From: Scott CareyDate: 2009-03-20 18:53:50
Subject: Re: Proposal of tunable fix for scalability of 8.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group