Filesystem benchmarking for pg 8.3.3 server

Поиск
Список
Период
Сортировка
От Henrik
Тема Filesystem benchmarking for pg 8.3.3 server
Дата
Msg-id 32A7A76B-16CA-4CDB-AD43-973AD6A3FC7B@mac.se
обсуждение исходный текст
Ответы Re: Filesystem benchmarking for pg 8.3.3 server  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-performance
Hello list,

I have a server with a direct attached storage containing 4 15k SAS
drives and 6 standard SATA drives.
The server is a quad core xeon with 16GB ram.
Both server and DAS has dual PERC/6E raid controllers with 512 MB BBU

There is 2 raid set configured.
One RAID 10 containing 4 SAS disks
One RAID 5 containing 6 SATA disks

There is one partition per RAID set with ext2 filesystem.

I ran the following iozone test which I stole from Joshua Drake's test
at

http://www.commandprompt.com/blogs/joshua_drake/2008/04/is_that_performance_i_smell_ext2_vs_ext3_on_50_spindles_testing_for_postgresql/

I ran this test against the RAID 5 SATA partition

#iozone -e -i0 -i1 -i2 -i8 -t1 -s 1000m -r 8k -+u

With these random write results

    Children see throughput for 1 random writers     =  168647.33 KB/sec
    Parent sees throughput for 1 random writers     =  168413.61 KB/sec
    Min throughput per process             =  168647.33 KB/sec
    Max throughput per process             =  168647.33 KB/sec
    Avg throughput per process             =  168647.33 KB/sec
    Min xfer                     = 1024000.00 KB
    CPU utilization: Wall time    6.072    CPU time    0.540    CPU
utilization   8.89 %

Almost 170 MB/sek. Not bad for 6 standard SATA drives.

Then I ran the same thing against the RAID 10 SAS partition

    Children see throughput for 1 random writers     =   68816.25 KB/sec
    Parent sees throughput for 1 random writers     =   68767.90 KB/sec
    Min throughput per process             =   68816.25 KB/sec
    Max throughput per process             =   68816.25 KB/sec
    Avg throughput per process             =   68816.25 KB/sec
    Min xfer                     = 1024000.00 KB
    CPU utilization: Wall time   14.880    CPU time    0.520    CPU
utilization   3.49 %

What only 70 MB/sek?

Is it possible that the 2 more spindles for the SATA drives makes that
partition soooo much faster? Even though the disks and the RAID
configuration should be slower?
It feels like there is something fishy going on. Maybe the RAID 10
implementation on the PERC/6e is crap?

Any pointers, suggestion, ideas?

I'm going to change the RAID 10 to a RAID 5 and test again and see
what happens.

Cheers,
Henke


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Restoration of datas
Следующее
От: "Joshua Shanks"
Дата:
Сообщение: Re: query planner not using the correct index