pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Francisco Reyes <lists@stringsutils.com>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Michael Stone <mstone+postgres@mathom.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Inserts optimization?
Date: Fri, 14 Apr 2006 16:27:59 -0400
Message-ID: <cone.1145046479.682584.283.5001@35st-server.simplicato.com> (raw)
References: <cone.1144888738.434948.92126.5001@35st-server.simplicato.com>
	<443DA715.4060606@gmail.com>
	<9549.1144903344@sss.pgh.pa.us>
	<cone.1144954763.735087.95544.5001@35st-server.simplicato.com>
	<20060414055923.GX49405@pervasive.com>
	<cone.1145014225.784898.23930.1000@zoraida.natserv.net>
	<20060414114911.GG32678@mathom.us>
	<cone.1145037716.354055.283.5001@35st-server.simplicato.com>
	<20060414190620.GH32678@mathom.us>
	<cone.1145045358.517551.283.5001@35st-server.simplicato.com>
	<1145045732.23538.86.camel@state.g2switchworks.com>

Scott Marlowe writes:

> Spares are placed in service one at a time.

Ah.. that's your point. I know that. :-)

>  You don't need 2 spares for
> RAID 10, trust me.

We bought the machine with 8 drives. At one point we were considering RAID 
5, then we decided to give RAID 10 a try. We have a simmilar machine with 
raid 5 and less memory (2GB, vs 4GB on the new machine)  and the old machine 
was having some very serious issues handling the load.

So far the RAID10 machine (twice the memory, newer disks, faster CPUs,.. 
the previous machine was about 1 year old) has been performing very well.

We are now looking to put our 3rd NFS machine into production with 
identical specs as the machine we currently use with RAID10. This 3rd 
machine with do NFS work (mail store) and also will be our database server 
(until we can afford to buy a 4th.. dedicated DB machine).

The whole reason I started the thread was because most PostgreSQL setups I 
have done in the past were mostly read.. whereas now the Bacula backups plus 
another app we will be developing.. will be doing considerable writes to the 
DB.



view thread (39+ messages)  latest in thread

Message-ID: <cone.1145046479.682584.283.5001@35st-server.simplicato.com>
Permalink:  ../cone.1145046479.682584.283.5001@35st-server.simplicato.com/
Also on:    postgresql.org/message-id/cone.1145046479.682584.283.5001@35st-server.simplicato.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: lists@stringsutils.com, smarlowe@g2switchworks.com, mstone+postgres@mathom.us
  Subject: Re: Inserts optimization?
  In-Reply-To: <cone.1145046479.682584.283.5001@35st-server.simplicato.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