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: (view raw, whole thread or download thread mbox)
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 , 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

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-2017 The PostgreSQL Global Development Group