Re: Best use of second controller with faster disks?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Jun 11, 2007, at 9:14 PM, Francisco Reyes wrote:

RAID card 1 with 8 drives. 7200 RPM SATA RAID10
RAID card 2 with 4 drives. 10K RPM SATA RAID10


what raid card have you got? i'm playing with an external enclosure which has an areca sata raid in it and connects to the host via fibre channel. it is wicked fast, and supports a RAID6 which seems to be as fast as the RAID10 in my initial testing on this unit.

What drives are you booting from? If you're booting from the 4-drive RAID10, perhaps split that into a pair of RAID1's and boot from one and use the other as the pg log disk.

however, I must say that with my 16 disk array, peeling the log off the main volume actually slowed it down a bit. I think that the raid card is just so fast at doing the RAID6 computations and having the striping is a big gain over the dedicated RAID1 for the log.

Right now I'm testing an 8-disk RAID6 configuration on the same device; it seems slower than the 16-disk RAID6, but I haven't yet tried 8-disk RAID10 with dedicated log yet.

Besides having pg_xlog in the 10K RPM drives what else can I do to best use those drives other than putting some data in them?

Iostat shows the drives getting used very little, even during constant updates and vacuum.

Some of the postgresl.conf settings that may be relevant.
wal_buffers = 64
checkpoint_segments = 64

i'd bump checkpoint_segements up to 256 given the amount of disk you've got dedicated to it. be sure to increase checkpoint timeout too.

And if you can move to 6.2 FreeBSD you should pick up some speed on the network layer and possibly the disk I/O.



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux