Re: large object write performance
От | Graeme B. Bell |
---|---|
Тема | Re: large object write performance |
Дата | |
Msg-id | 465F0A34-AE24-457A-8B3E-60440862D7EF@skogoglandskap.no обсуждение исходный текст |
Ответ на | large object write performance (Bram Van Steenlandt <bram@diomedia.be>) |
Ответы |
Re: large object write performance
|
Список | pgsql-performance |
>> First the database was on a partition where compression was enabled, I changed it to an uncompressed one to see if itmakes a difference thinking maybe the cpu couldn't handle the load. > It made little difference in my case. > > My regular gmirror partition seems faster: > dd bs=8k count=25600 if=/dev/zero of=./test > 25600+0 records in > 25600+0 records out > 209715200 bytes transferred in 1.513112 secs (138598612 bytes/sec) > > the zfs compressed partition also goes faster: > dd bs=8k count=25600 if=/dev/zero of=./test > 25600+0 records in > 25600+0 records out > 209715200 bytes transferred in 0.979065 secs (214199479 bytes/sec) > but this one didn't really go that fast in my test (maybe 10%) Please can you run iozone and look for low random write performance with small blocks? (4k) http://www.slashroot.in/linux-file-system-read-write-performance-test Also please can you CC to the list with your replies to my on-list emails? Graeme Bell
В списке pgsql-performance по дате отправления: