Re: Very high effective_cache_size == worse performance?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Very high effective_cache_size == worse performance?
Date: 2010-04-20 18:15:54
Message-ID: u2odcc563d11004201115m7585abe3xf1e7116cd71423bf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Apr 20, 2010 at 11:39 AM, David Kerr <dmk(at)mr-paradox(dot)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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2010-04-20 18:17:02 Re: Very high effective_cache_size == worse performance?
Previous Message Robert Haas 2010-04-20 18:15:19 Re: Very high effective_cache_size == worse performance?