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

Re: Very high effective_cache_size == worse performance?

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Nikolas Everett <nik9000(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Very high effective_cache_size == worse performance?
Date: 2010-04-21 06:45:55
Message-ID: 4BCE9F23.1080000@2ndquadrant.com (view raw or flat)
Thread:
Lists: 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(at)2ndQuadrant(dot)com   www.2ndQuadrant.us


In response to

pgsql-performance by date

Next:From: nornDate: 2010-04-21 08:24:08
Subject: Re: significant slow down with various LIMIT
Previous:From: Tom LaneDate: 2010-04-21 03:47:01
Subject: Re: performance change from 8.3.1 to later releases

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