Re: Postgres on RAID5

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Alex Turner <armtuk(at)gmail(dot)com>
Cc: Arshavir Grigorian <ag(at)m-cam(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres on RAID5
Date: 2005-03-12 04:05:54
Message-ID: 42326AA2.1010700@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>On Fri, 11 Mar 2005 16:13:05 -0500, Arshavir Grigorian <ag(at)m-cam(dot)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(at)postgresql(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 285 bytes

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tambet Matiisen 2005-03-12 13:08:32 One tuple per transaction
Previous Message Alex Turner 2005-03-12 03:50:20 Re: Postgres on RAID5