pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andreas Pflug <Andreas.Pflug@web.de>
To: pgsql-performance@postgresql.org
Subject: Re: how to configure my new server
Date: Fri, 07 Feb 2003 19:42:48 +0100
Message-ID: <3E43FE28.7030203@web.de> (raw)
In-Reply-To: <Pine.LNX.4.33.0302071028060.14028-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0302071028060.14028-100000@css120.ihs.com>

scott.marlowe wrote:

>I can get aggregate reads of about 48 Megs a second on a pair of 10k 18 
>gig UW scsi drives in RAID1 config.  I'm not saying there's no room for 
>improvement, but for what I use it for, it gives very good performance.
>
>  
>
Scott,

as most people talking about performance you mean throughput, but this 
is not the most important parameter for databases. Reading the comments 
of other users with software and IDE RAID, it seems to me that indeed 
these solutions are only good at this discipline.

Another suggestion:
You're right, a hardware RAID controller is nothing but a stripped down 
system that does noting more than a software RAID would do either. But 
this tends to be the discussion that Intels plays for years now. There 
were times when Intel said "don't need an intelligent graphics 
controller, just use a fast processor". Well, development went another 
direction, and it's good this way. Same with specialized controllers. 
They will take burden from the central processing unit, which can 
concentrate on the complicated things, not just getting some block from 
disk. Look at most Intel based servers. Often, CPU Speed is less than 
workstations CPUs, RAM technology one step behind. But they have 
sophisticated infrastructure for coprocessing. This is the way to speed 
things up, not pumping up the CPU.

If you got two of three HDs bad in a RAID5 array, you're lost. That's 
the case for all RAID5 solutions, because the redundancy is just one 
disk. Better solutions will allow for spare disks that jump in as soon 
as one fails, hopefully it rebuilds before the next fails.


Regards,

Andreas







view thread (27+ messages)  latest in thread

Message-ID: <3E43FE28.7030203@web.de>
Permalink:  ../3E43FE28.7030203@web.de/
Also on:    postgresql.org/message-id/3E43FE28.7030203@web.de

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: Andreas.Pflug@web.de
  Subject: Re: how to configure my new server
  In-Reply-To: <3E43FE28.7030203@web.de>
  References: <Pine.LNX.4.33.0302071028060.14028-100000@css120.ihs.com> <3E43FE28.7030203@web.de>

* 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