Re: [PERFORM] more filesystem benchmarks

2005-07-16 Thread Michael Stone
On Sat, Jul 16, 2005 at 01:12:27AM -0700, Jeffrey W. Baker wrote: Another frequent suggestion is to put the xlog on a separate device. I tried this, and, for a given number of disks, it appears to be counter-productive. A RAID5 of 5 disks holding both logs and data is about 15% faster than a RA

[PERFORM] more filesystem benchmarks

2005-07-16 Thread Jeffrey W. Baker
In our last installment, we saw that JFS provides higher pgbench performance than either XFS or ext3. Using a direct-I/O patch stolen from 8.1, JFS achieved 105 tps with 100 clients. To refresh, the machine in question has 5 7200RPM SATA disks, an Areca RAID controller with 128MB cache, and 1GB o