Re: Full statement logging problematic on larger machines? - Mailing list pgsql-performance

From Frank Joerdens
Subject Re: Full statement logging problematic on larger machines?
Date
Msg-id 7d10d2df0903201201x470bdbb9gfdee702a4157f31b@mail.gmail.com
Whole thread Raw
In response to Re: Full statement logging problematic on larger machines?  (Laurent Laborde <kerdezixe@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4
Next
From: Robert Haas
Date:
Subject: Re: Need help with one query