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.
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