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

From Greg Smith
Subject Re: Very high effective_cache_size == worse performance?
Date
Msg-id 4BCE9F23.1080000@2ndquadrant.com
Whole thread Raw
In response to Re: Very high effective_cache_size == worse performance?  (David Kerr <dmk@mr-paradox.net>)
List pgsql-performance
David Kerr wrote:
> I don't think it's anything in the Db that's causing it. ( drop and re-create
> the db between tests) I actually suspect a hardware issue somewhere.
>

You might find my "Database Hardware Benchmarking" talk, available at
http://projects.2ndquadrant.com/talks , useful to help sort out what's
good and bad on each server, and correspondingly what'd different
between the two.  Many of the ideas there came from fighting with SAN
hardware that didn't do what I expected.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: performance change from 8.3.1 to later releases
Next
From: "Kevin Grittner"
Date:
Subject: Re: significant slow down with various LIMIT