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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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