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 AC4BB566C2 for ; Sat, 12 Mar 2005 04:04:43 +0000 (GMT) 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 78537-08 for ; Sat, 12 Mar 2005 04:04:38 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id E15E6566B5 for ; Sat, 12 Mar 2005 04:04:37 +0000 (GMT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j2C42nkh015718; Fri, 11 Mar 2005 20:02:49 -0800 Message-ID: <42326AA2.1010700@commandprompt.com> Date: Fri, 11 Mar 2005 20:05:54 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alex Turner Cc: Arshavir Grigorian , pgsql-performance@postgresql.org Subject: Re: Postgres on RAID5 References: <423209E1.6090200@m-cam.com> <33c6269f05031119506fee5c31@mail.gmail.com> In-Reply-To: <33c6269f05031119506fee5c31@mail.gmail.com> Content-Type: multipart/mixed; boundary="------------010304040703040007050409" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.04 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/210 X-Sequence-Number: 10915 This is a multi-part message in MIME format. --------------010304040703040007050409 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit >On Fri, 11 Mar 2005 16:13:05 -0500, Arshavir Grigorian wrote: > > >>Hi, >> >>I have a RAID5 array (mdadm) with 14 disks + 1 spare. This partition has >>an Ext3 filesystem which is used by Postgres. Currently we are loading a >>50G database on this server from a Postgres dump (copy, not insert) and >>are experiencing very slow write performance (35 records per second). >> >> That isn't that surprising. RAID 5 has never been known for its write performance. You should be running RAID 10. Sincerely, Joshua D. Drake >>Top shows that the Postgres process (postmaster) is being constantly put >>into D state for extended periods of time (2-3 seconds) which I assume >>is because it's waiting for disk io. I have just started gathering >>system statistics and here is what sar -b shows: (this is while the db >>is being loaded - pg_restore) >> >> tps rtps wtps bread/s bwrtn/s >>01:35:01 PM 275.77 76.12 199.66 709.59 2315.23 >>01:45:01 PM 287.25 75.56 211.69 706.52 2413.06 >>01:55:01 PM 281.73 76.35 205.37 711.84 2389.86 >> >> >> >[snip] > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------010304040703040007050409 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------010304040703040007050409--