Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group