pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Arshavir Grigorian <ag@m-cam.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres on RAID5
Date: Fri, 11 Mar 2005 17:29:11 -0500
Message-ID: <42321BB7.9030808@m-cam.com> (raw)
In-Reply-To: <5669.1110578855@sss.pgh.pa.us>
References: <423209E1.6090200@m-cam.com>
	<5669.1110578855@sss.pgh.pa.us>

Tom Lane wrote:
> Arshavir Grigorian <ag@m-cam.com> 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




view thread (26+ messages)  latest in thread

Message-ID: <42321BB7.9030808@m-cam.com>
Permalink:  ../42321BB7.9030808@m-cam.com/
Also on:    postgresql.org/message-id/42321BB7.9030808@m-cam.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: ag@m-cam.com, tgl@sss.pgh.pa.us
  Subject: Re: Postgres on RAID5
  In-Reply-To: <42321BB7.9030808@m-cam.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