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
In response to
pgsql-performance by date
|Next:||From: norn||Date: 2010-04-21 08:24:08|
|Subject: Re: significant slow down with various LIMIT|
|Previous:||From: Tom Lane||Date: 2010-04-21 03:47:01|
|Subject: Re: performance change from 8.3.1 to later releases |