pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Alex Turner <armtuk@gmail.com>
Cc: Arshavir Grigorian <ag@m-cam.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres on RAID5
Date: Fri, 11 Mar 2005 20:05:54 -0800
Message-ID: <42326AA2.1010700@commandprompt.com> (raw)
In-Reply-To: <33c6269f05031119506fee5c31@mail.gmail.com>
References: <423209E1.6090200@m-cam.com>
	<33c6269f05031119506fee5c31@mail.gmail.com>


>On Fri, 11 Mar 2005 16:13:05 -0500, Arshavir Grigorian <ag@m-cam.com> 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

Attachments:

jd.vcf (text/x-vcard, 283B) download 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

view thread (26+ messages)  latest in thread

Message-ID: <42326AA2.1010700@commandprompt.com>
Permalink:  ../42326AA2.1010700@commandprompt.com/
Also on:    postgresql.org/message-id/42326AA2.1010700@commandprompt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jd@commandprompt.com, armtuk@gmail.com, ag@m-cam.com
  Subject: Re: Postgres on RAID5
  In-Reply-To: <42326AA2.1010700@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox