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