Re: Filesystem benchmarking for pg 8.3.3 server

Поиск
Список
Период
Сортировка
От Jeff
Тема Re: Filesystem benchmarking for pg 8.3.3 server
Дата
Msg-id 2DBD3E73-D9E5-4DFA-832F-3FD53480B284@torgo.978.org
обсуждение исходный текст
Ответ на Re: Filesystem benchmarking for pg 8.3.3 server  (Henrik <henke@mac.se>)
Ответы Re: Filesystem benchmarking for pg 8.3.3 server
Список pgsql-performance
On Aug 11, 2008, at 5:17 AM, Henrik wrote:

> OK, changed the SAS RAID 10 to RAID 5 and now my random writes are
> handing 112 MB/ sek. So it is almsot twice as fast as the RAID10
> with the same disks. Any ideas why?
>
> Is the iozone tests faulty?


does IOzone disable the os caches?
If not you need to use a size of 2xRAM for true results.

regardless - the test only took 10 seconds of wall time - which isn't
very long at all. You'd probably want to run it longer anyway.


>
> iozone -e -i0 -i1 -i2 -i8 -t1 -s 1000m -r 8k -+u -F /database/iotest
>
>     Children see throughput for 1 random writers     =  112074.58 KB/sec
>     Parent sees throughput for 1 random writers     =  111962.80 KB/sec
>     Min throughput per process             =  112074.58 KB/sec
>     Max throughput per process             =  112074.58 KB/sec
>     Avg throughput per process             =  112074.58 KB/sec
>     Min xfer                     = 1024000.00 KB
>     CPU utilization: Wall time    9.137    CPU time    0.510    CPU
> utilization   5.58 %
>


--
Jeff Trout <jeff@jefftrout.com>
http://www.stuarthamm.net/
http://www.dellsmartexitin.com/




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

Предыдущее
От: "Sven Clement"
Дата:
Сообщение:
Следующее
От: "Fernando Hevia"
Дата:
Сообщение: Re: Distant mirroring