Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig

Поиск
Список
Период
Сортировка
От Luke Lonergan
Тема Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
Дата
Msg-id 3E37B936B592014B978C4415F90D662D03E6CE74@MI8NYCMAIL06.Mi8.com
обсуждение исходный текст
Список pgsql-performance
Charles,

> FWIW, once our vendor gets all the pieces (having some issues
> with figuring out which multilane sata cables to get), I'll
> have a dual-core opteron box with a 3Ware 9500SX-12MI and 8
> drives.  I need to benchmark to compare this to our
> xeon/adaptec/scsi build we've been using.

Cool!  You mean the 9550SX, not the 9500, right?

A trick on the 9550SX with Linux is to set the max readahead to 512KB
and no larger when using RAID10.  If you use RAID5, set it to 16MB.

Here is how you set it (put in /etc/rc.d/rc.local) for 512KB on
/dev/sda:

  /sbin/blockdev --setra 512 /dev/sda

I was able to go from 310MB/s on 8 drives to 475MB/s that way (using
XFS).

Also, you need to stay away from Linux Volume Manager (lvm and lvm2),
they add a lot of overhead (!!?) to the block access.  It took me a long
time to figure that out!

- Luke


В списке pgsql-performance по дате отправления:

Предыдущее
От: Charles Sprickman
Дата:
Сообщение: Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
Следующее
От: Jochem van Dieten
Дата:
Сообщение: PostgreSQL scalability on Sun UltraSparc T1