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: 7d10d2df0903201201x470bdbb9gfdee702a4157f31b@mail.gmail.com (view raw or flat)
Thread:
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!

Regards,

Frank

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-2014 The PostgreSQL Global Development Group