On 01/17/2012 03:47 PM, Kevin Grittner wrote:
I'm very curious about what impact DW would have on big servers with write-back cache that becomes saturated, like in Greg Smith's post here...
My guess is that a percentage of the dbt-2 run results posted here are hitting that sort of problem. We just don't know which, because the results numbers posted were all the throughput numbers. I haven't figure out a way to look for cache saturation issues other than collecting all the latency information for each transaction, then graphing that out if the worst-case value is poor. It's quite possible they have that data but just didn't post just to keep the summary size managable, since dbt-2 collects a lot of information.
-- Greg Smith 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers