Postgres Pro
Downloads
Home   >   mailing lists

Re: Very high effective_cache_size == worse performance? - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Very high effective_cache_size == worse performance?
Date
Msg-id u2odcc563d11004201115m7585abe3xf1e7116cd71423bf@mail.gmail.com
Whole thread Raw
In response to Very high effective_cache_size == worse performance?  (David Kerr <dmk@mr-paradox.net>)
Responses Re: Very high effective_cache_size == worse performance?
List pgsql-performance
Tree view 
On Tue, Apr 20, 2010 at 11:39 AM, David Kerr <dmk@mr-paradox.net> wrote:
> Howdy all,
>
> I've got a huge server running just postgres. It's got 48 cores and 256GB of ram. Redhat 5.4, Postgres 8.3.9.
> 64bit OS. No users currently.

What's your IO subsystem look like?  What did vmstat actually say?

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Very high effective_cache_size == worse performance?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Very high effective_cache_size == worse performance?