Re: [PATCHES] COPY FROM performance improvements - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: [PATCHES] COPY FROM performance improvements
Date
Msg-id 42E970E4.4010902@commandprompt.com
Whole thread Raw
In response to Re: [PATCHES] COPY FROM performance improvements  (Mark Wong <markw@osdl.org>)
Responses Re: [PATCHES] COPY FROM performance improvements
List pgsql-performance
>>
>>>[root@pq-slave root]# /sbin/hdparm -tT /dev/sda
>>>
>>>/dev/sda:
>>>  Timing buffer-cache reads:   1816 MB in  2.00 seconds = 908.00 MB/sec
>>>  Timing buffered disk reads:   26 MB in  3.11 seconds =   8.36 MB/sec
>>>[root@pq-slave root]#
>>
>>Can you post the "time dd if=/dev/zero of=bigfile bs=8k count=500000"
>>results?  Also do the reverse (read the file) with "time dd if=bigfile
>>of=/dev/null bs=8k".

I didn't see this come across before... here ya go:

time dd if=/dev/zero of=bigfile bs=8k count=500000

500000+0 records in
500000+0 records out

real    1m52.738s
user    0m0.310s
sys     0m36.590s

time dd if=bigfile of=/dev/null bs=8k

time dd if=bigfile of=/dev/null bs=8k
500000+0 records in
500000+0 records out

real    4m38.742s
user    0m0.320s
sys     0m27.870s


FYI on your hardware raid comment... I easily get 50 megs a second on my
3ware controllers and faster on my LSI SATA controllers.

Sincerely,

Joshua D. Drake




>
--
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org

pgsql-performance by date:

Previous
From: Mark Wong
Date:
Subject: Re: [PATCHES] COPY FROM performance improvements
Next
From: Matthew Schumacher
Date:
Subject: Re: Performance problems testing with Spamassassin 3.1.0