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 h2xdcc563d11004201224wc7471e0dx335ab345d37f04ca@mail.gmail.com
Whole thread Raw
In response to Re: Very high effective_cache_size == worse performance?  (David Kerr <dmk@mr-paradox.net>)
List pgsql-performance
On Tue, Apr 20, 2010 at 12:28 PM, David Kerr <dmk@mr-paradox.net> wrote:
> On Tue, Apr 20, 2010 at 12:23:51PM -0600, Scott Marlowe wrote:
> - So are you logging to the same drive that has pg_xlog and your
> - data/base directory on this machine?
> -
>
> the db, xlog and logs are all on separate areas of the SAN.
>
> separate I/O controllers, etc on the SAN. it's setup well, I wouldn't expect
> contention there.

Same xkb/s gigabit connection?

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Very high effective_cache_size == worse performance?
Next
From: Dave Crooke
Date:
Subject: Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set