On Tue, Jan 31, 2006 at 08:09:40PM -0800, Jeffrey W. Baker wrote:
I think I've proved my point. Software RAID1 read balancing provides 0%, 300%, 100%, and 100% speedup on 1, 2, 4, and 8 threads, respectively. In the presence of random I/O, the results are even better.
Umm, the point *was* about single stream performance. I guess you did a good job of proving it.
Anyone who thinks they have a single-threaded workload has not yet encountered the autovacuum daemon.
On tables where my single stream performance matters you'd better believe that the autovacuum daemon isn't running.
Mike Stone
