Re: [PERFORM] Hosted servers with good DB disk performance?

2009-06-10 Thread Markus Wanner
such an offering would exist for Europe (guess that's just a matter of time). Regards Markus Wanner -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] block device benchmarking

2009-01-11 Thread Markus Wanner
n how long it takes me to get the > PostgreSQL benchmarks I'm using to work on my machine. But everything > will be on Github at > > http://github.com/znmeb/linux_perf_viz/tree/master/blktrace-howto > > as it evolves. Cool, looking forward to reading that. Regards Markus W

Re: [PERFORM] understanding postgres issues/bottlenecks

2009-01-10 Thread Markus Wanner
ce. So there are pretty awful spikes for writing latency (IIRC more than 100ms has been measured on cheaper disks). A battery backed cache could theoretically flatten those, as long as your avg. WAL throughput is below the SSDs avg. writing throughput. Regards Markus Wanner -- Sent via pgsql-

[PERFORM] block device benchmarking

2009-01-10 Thread Markus Wanner
ant for all types of storages.) Does there already exist a tool giving (most of) these measures? Am I missing something interesting? What would you expect from a block device benchmarking tool? Regards Markus Wanner -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To

Re: [PERFORM] Fusion-io ioDrive

2008-07-08 Thread Markus Wanner
Hi, Jonah H. Harris wrote: I'm not sure how those cards work, but my guess is that the CPU will go 100% busy (with a near-zero I/O wait) on any sizable workload. In this case, the current pgbench configuration being used is quite small and probably won't resemble this. I'm not sure how they w