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 1283656530 for ; Fri, 11 Mar 2005 22:29:21 +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 94027-03 for ; Fri, 11 Mar 2005 22:29:17 +0000 (GMT) Received: from mail2.m-cam.com (unknown [63.124.102.77]) by svr1.postgresql.org (Postfix) with ESMTP id 86F185644B for ; Fri, 11 Mar 2005 22:29:16 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail2.m-cam.com (Postfix) with ESMTP id 81E443E8F7; Fri, 11 Mar 2005 17:34:08 -0500 (EST) Received: from mail2.m-cam.com ([127.0.0.1]) by localhost (mail2.m-cam.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21471-06; Fri, 11 Mar 2005 17:34:04 -0500 (EST) Received: from [192.168.1.21] (unknown [192.168.1.21]) by mail2.m-cam.com (Postfix) with ESMTP id 06C9A3E8F1; Fri, 11 Mar 2005 17:34:03 -0500 (EST) Message-ID: <42321BB7.9030808@m-cam.com> Date: Fri, 11 Mar 2005 17:29:11 -0500 From: Arshavir Grigorian User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: Postgres on RAID5 References: <423209E1.6090200@m-cam.com> <5669.1110578855@sss.pgh.pa.us> In-Reply-To: <5669.1110578855@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at m-cam.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/202 X-Sequence-Number: 10907 Tom Lane wrote: > Arshavir Grigorian writes: > >>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). > > > What PG version is this? What version of pg_dump made the dump file? > How are you measuring that write rate (seeing that pg_restore doesn't > provide any such info)? Sorry I missed the version. Both (the db from which the dump was created and the one it's being loaded on) run on Pg 7.4. Well, if the restore is going on for X number of hours and you have Y records loaded, it's not hard to ballpark. > > >>Postgres is installed from the Debian package and uses >>all the configuration defaults. > > > The defaults are made for a fairly small machine, not big iron. At a > minimum you want to kick shared_buffers up to 10K or more. > > regards, tom lane Will do. Thanks. Arshavir