pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Douglas McNaught <doug@mcnaught.org>
Cc: Vivek Khera <vivek@khera.org>
Cc: Pgsql-Performance ((E-mail)) <pgsql-performance@postgresql.org>
Cc: PostgreSQL General <pgsql-general@postgresql.org>
Subject: Re: [PERFORM] Arguments Pro/Contra Software Raid
Date: Tue, 09 May 2006 11:43:16 -0700
Message-ID: <4460E2C4.2020804@commandprompt.com> (raw)
In-Reply-To: <87mzdroyzb.fsf@suzuka.mcnaught.org>
References: <e3pmkc$12mk$1@news.hub.org>
	<473FC220-A52C-4954-81E9-A14ED33164C2@blighty.com>
	<4460BA8B.7010600@commandprompt.com>
	<5AF87D32-F602-4973-AA21-84E0CFEA1774@khera.org>
	<87mzdroyzb.fsf@suzuka.mcnaught.org>

Douglas McNaught wrote:
> Vivek Khera <vivek@khera.org> writes:
> 
>> On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
>>
>>> And dollar for dollar, SCSI will NOT be faster nor have the hard
>>> drive capacity that you will get with SATA.
>> Does this hold true still under heavy concurrent-write loads?  I'm
>> preparing yet another big DB server and if SATA is a better option,
>> I'm all (elephant) ears.
> 
> Correct me if I'm wrong, but I've never heard of a 15kRPM SATA drive.

Best I have seen is 10k but if I can put 4x the number of drives in the 
array at the same cost... I don't need 15k.

Joshua D. Drake

> 
> -Doug
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
> 


-- 

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/





view thread (49+ messages)  latest in thread

Message-ID: <4460E2C4.2020804@commandprompt.com>
Permalink:  ../4460E2C4.2020804@commandprompt.com/
Also on:    postgresql.org/message-id/4460E2C4.2020804@commandprompt.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: jd@commandprompt.com, doug@mcnaught.org, vivek@khera.org, pgsql-general@postgresql.org
  Subject: Re: [PERFORM] Arguments Pro/Contra Software Raid
  In-Reply-To: <4460E2C4.2020804@commandprompt.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