X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EF8B652A48 for ; Thu, 28 Jul 2005 20:57:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53326-06 for ; Thu, 28 Jul 2005 23:57:54 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 6FDA452A38 for ; Thu, 28 Jul 2005 20:57:52 -0300 (ADT) Received: from [192.168.1.101] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id j6SNv7M6023411; Thu, 28 Jul 2005 16:57:08 -0700 Message-ID: <42E970E4.4010902@commandprompt.com> Date: Thu, 28 Jul 2005 16:57:24 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050404) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Mark Wong Cc: Luke Lonergan , Patrick Welche , pgsql-performance@postgresql.org, maryedie@osdl.org Subject: Re: [PATCHES] COPY FROM performance improvements References: <42E128BD.2000104@commandprompt.com> <200507282343.j6SNhEjA013300@smtp.osdl.org> In-Reply-To: <200507282343.j6SNhEjA013300@smtp.osdl.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/448 X-Sequence-Number: 13689 >> >>>[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