pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Cott Lang <cott@internetstaff.com>
To: pgsql-general@postgresql.org
Subject: Re: [PERFORM] best arrangement of 3 disks for (insert)
Date: Mon, 15 Sep 2003 07:41:11 -0700
Message-ID: <1063636871.17237.28.camel@blackbox> (raw)
In-Reply-To: <1063613110.11739.1190.camel@haggis>
References: <200309121126.29756.rj@last.fm>
	<60fzj2t4g6.fsf@dev6.int.libertyrms.info>
	<1063514688.27300.11.camel@blackbox>
	<1063613110.11739.1190.camel@haggis>

On Mon, 2003-09-15 at 01:05, Ron Johnson wrote:

> Interesting.  Where did you put the OS, and what kind of, and how
> many, SCSI controllers did you have?  

I ended up with the OS on the same volume, since it didn't seem to make
any difference.  I'm using a SuperMicro 6023P chassis with an Adaptec
2010S ZCR controller (64bit/66mhz). 

I wouldn't recommend SuperMicro to anyone else at this point because
instead of hooking up both U320 channels to the 6 drive backplane, they
only hook up one.  Half the bandwidth, no redundancy. I already had a
burp on the SCSI channel during a single drive death take out one box.
:(

> (If the WAL ever becomes the vehicle for PITR, then it will have 
> to be on a separate disk [and preferably a separate controller], 
> even if it slows performance.)

Well, it won't have to... but it's certainly a good idea. :)

If we ever get PITR, I'll be so happy I won't mind rebuilding my boxes,
and hopefully I'll have a better budget at that point. ;^)

BTW, I didn't get WORSE performance with the WALs on separate disks, it
just wasn't any better. Unfortunately I lost the spreadsheet I had all
my results in, so I can't be any more specific.





Message-ID: <1063636871.17237.28.camel@blackbox>
Permalink:  ../1063636871.17237.28.camel@blackbox/
Also on:    postgresql.org/message-id/1063636871.17237.28.camel@blackbox

 · 

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: cott@internetstaff.com, pgsql-general@postgresql.org
  Subject: Re: [PERFORM] best arrangement of 3 disks for (insert)
  In-Reply-To: <1063636871.17237.28.camel@blackbox>
  References: <200309121126.29756.rj@last.fm> <60fzj2t4g6.fsf@dev6.int.libertyrms.info> <1063514688.27300.11.camel@blackbox> <1063613110.11739.1190.camel@haggis> <1063636871.17237.28.camel@blackbox>

* 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