Re: Very high effective_cache_size == worse performance?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx   www.2ndQuadrant.us


--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux