pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedsuggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
9+ messages / 7 participants
[nested] [flat]
* suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
@ 2006-07-05 23:46 Kenji Morishige <kenjim@juniper.net>
2006-07-06 00:52 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood <markir@paradise.net.nz>
2006-07-10 14:52 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Vivek Khera <vivek@khera.org>
0 siblings, 2 replies; 9+ messages in thread
From: Kenji Morishige @ 2006-07-05 23:46 UTC (permalink / raw)
To: pgsql-performance; +Cc: kenjim@juniper.net
I am currently running FreeBSD 4.11 (due to IT requirements for now) and
Adaptec's 2200S RAID controller running in RAID5. I was advised in the past
that the 2200S is actually a poor performing controller and obviously the
RAID5 is less than ideal for databases. I chose to run the controller in
RAID5 as the tech I talked to suggested that the 2200S was primarily designed
for RAID5 and it would operate the best that way. My server is a dual Xeon
3.06Ghz box running on a motherboard approximately 2-3 years old now. I'd
like to know what an ideal RAID controller that would be compatible with
FreeBSD 6.1 would be these days.
Thanks in advance,
Kenji
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL
2006-07-05 23:46 suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
@ 2006-07-06 00:52 ` Mark Kirkwood <markir@paradise.net.nz>
2006-07-06 18:10 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
1 sibling, 1 reply; 9+ messages in thread
From: Mark Kirkwood @ 2006-07-06 00:52 UTC (permalink / raw)
To: Kenji Morishige <kenjim@juniper.net>; +Cc: pgsql-performance
Kenji Morishige wrote:
> I am currently running FreeBSD 4.11 (due to IT requirements for now) and
> Adaptec's 2200S RAID controller running in RAID5. I was advised in the past
> that the 2200S is actually a poor performing controller and obviously the
> RAID5 is less than ideal for databases. I chose to run the controller in
> RAID5 as the tech I talked to suggested that the 2200S was primarily designed
> for RAID5 and it would operate the best that way. My server is a dual Xeon
> 3.06Ghz box running on a motherboard approximately 2-3 years old now. I'd
> like to know what an ideal RAID controller that would be compatible with
> FreeBSD 6.1 would be these days.
>
>
I've had good experience with 3Ware on FreeBSD - painless installs and
excellent performance! (in my case the older 7506 models for (P)ATA on
4.10, 5.4, 6.0 and 6.1).
It looks like the new 9550 series is supported in 6.1 onwards. Given
that this has been added recently I would suggest mailing
freebsd-hardware to see what experiences folks are having (I don't
recall seeing any postings about issues with the 9000 or 9550 series).
Cheers
Mark
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
2006-07-05 23:46 suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
2006-07-06 00:52 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood <markir@paradise.net.nz>
@ 2006-07-06 18:10 ` Kenji Morishige <kenjim@juniper.net>
2006-07-06 18:17 ` Re: suggested RAID controller for FreeBSD 6.1 + Scott Marlowe <smarlowe@g2switchworks.com>
2006-07-06 18:21 ` Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL 8.1 Paul Khavkine <paul.khavkine@distributel.ca>
2006-07-06 22:51 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood <markir@paradise.net.nz>
0 siblings, 3 replies; 9+ messages in thread
From: Kenji Morishige @ 2006-07-06 18:10 UTC (permalink / raw)
To: Mark Kirkwood <markir@paradise.net.nz>; +Cc: pgsql-performance; kenjim@juniper.net
Thanks for the suggestion Mark, though the server chassis I am trying to
utilize already has 4 10,000 RPM SCSI drives with SCA interfaces. Ideally I
would like to use the existing drives and chassis and find another SCSI RAID
controller. It looks like 3Ware only makes ATA controllers.
-Kenji
On Thu, Jul 06, 2006 at 12:52:09PM +1200, Mark Kirkwood wrote:
> Kenji Morishige wrote:
> >I am currently running FreeBSD 4.11 (due to IT requirements for now) and
> >Adaptec's 2200S RAID controller running in RAID5. I was advised in the
> >past
> >that the 2200S is actually a poor performing controller and obviously the
> >RAID5 is less than ideal for databases. I chose to run the controller in
> >RAID5 as the tech I talked to suggested that the 2200S was primarily
> >designed
> >for RAID5 and it would operate the best that way. My server is a dual Xeon
> > 3.06Ghz box running on a motherboard approximately 2-3 years old now.
> > I'd
> >like to know what an ideal RAID controller that would be compatible with
> >FreeBSD 6.1 would be these days.
> >
> >
>
> I've had good experience with 3Ware on FreeBSD - painless installs and
> excellent performance! (in my case the older 7506 models for (P)ATA on
> 4.10, 5.4, 6.0 and 6.1).
>
> It looks like the new 9550 series is supported in 6.1 onwards. Given
> that this has been added recently I would suggest mailing
> freebsd-hardware to see what experiences folks are having (I don't
> recall seeing any postings about issues with the 9000 or 9550 series).
>
> Cheers
>
> Mark
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: suggested RAID controller for FreeBSD 6.1 +
2006-07-05 23:46 suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
2006-07-06 00:52 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood <markir@paradise.net.nz>
2006-07-06 18:10 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
@ 2006-07-06 18:17 ` Scott Marlowe <smarlowe@g2switchworks.com>
2 siblings, 0 replies; 9+ messages in thread
From: Scott Marlowe @ 2006-07-06 18:17 UTC (permalink / raw)
To: Kenji Morishige <kenjim@juniper.net>; +Cc: Mark Kirkwood <markir@paradise.net.nz>; pgsql-performance
On Thu, 2006-07-06 at 13:10, Kenji Morishige wrote:
> Thanks for the suggestion Mark, though the server chassis I am trying to
> utilize already has 4 10,000 RPM SCSI drives with SCA interfaces. Ideally I
> would like to use the existing drives and chassis and find another SCSI RAID
> controller. It looks like 3Ware only makes ATA controllers.
Take a look at LSI. They make solid and reliable SCSI RAID
controllers. be sure and get the BBU cache.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL 8.1
2006-07-05 23:46 suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
2006-07-06 00:52 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood <markir@paradise.net.nz>
2006-07-06 18:10 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
@ 2006-07-06 18:21 ` Paul Khavkine <paul.khavkine@distributel.ca>
2006-07-07 05:08 ` Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL Michael Loftis <mloftis@wgops.com>
2 siblings, 1 reply; 9+ messages in thread
From: Paul Khavkine @ 2006-07-06 18:21 UTC (permalink / raw)
To: Kenji Morishige <kenjim@juniper.net>; +Cc: Mark Kirkwood <markir@paradise.net.nz>; pgsql-performance
Take a look at: http://www.icp-vortex.com/english/index_e.htm
They have always made good RAID controllers.
Cheers
Paul
On Thu, 2006-07-06 at 11:10 -0700, Kenji Morishige wrote:
> Thanks for the suggestion Mark, though the server chassis I am trying to
> utilize already has 4 10,000 RPM SCSI drives with SCA interfaces. Ideally I
> would like to use the existing drives and chassis and find another SCSI RAID
> controller. It looks like 3Ware only makes ATA controllers.
> -Kenji
>
> On Thu, Jul 06, 2006 at 12:52:09PM +1200, Mark Kirkwood wrote:
> > Kenji Morishige wrote:
> > >I am currently running FreeBSD 4.11 (due to IT requirements for now) and
> > >Adaptec's 2200S RAID controller running in RAID5. I was advised in the
> > >past
> > >that the 2200S is actually a poor performing controller and obviously the
> > >RAID5 is less than ideal for databases. I chose to run the controller in
> > >RAID5 as the tech I talked to suggested that the 2200S was primarily
> > >designed
> > >for RAID5 and it would operate the best that way. My server is a dual Xeon
> > > 3.06Ghz box running on a motherboard approximately 2-3 years old now.
> > > I'd
> > >like to know what an ideal RAID controller that would be compatible with
> > >FreeBSD 6.1 would be these days.
> > >
> > >
> >
> > I've had good experience with 3Ware on FreeBSD - painless installs and
> > excellent performance! (in my case the older 7506 models for (P)ATA on
> > 4.10, 5.4, 6.0 and 6.1).
> >
> > It looks like the new 9550 series is supported in 6.1 onwards. Given
> > that this has been added recently I would suggest mailing
> > freebsd-hardware to see what experiences folks are having (I don't
> > recall seeing any postings about issues with the 9000 or 9550 series).
> >
> > Cheers
> >
> > Mark
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
Attachments:
signature.asc (application/pgp-signature, 304B) download
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL
2006-07-05 23:46 suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
2006-07-06 00:52 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood <markir@paradise.net.nz>
2006-07-06 18:10 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
2006-07-06 18:21 ` Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL 8.1 Paul Khavkine <paul.khavkine@distributel.ca>
@ 2006-07-07 05:08 ` Michael Loftis <mloftis@wgops.com>
0 siblings, 0 replies; 9+ messages in thread
From: Michael Loftis @ 2006-07-07 05:08 UTC (permalink / raw)
To: pgsql-performance
--On July 6, 2006 2:21:15 PM -0400 Paul Khavkine
<paul.khavkine@distributel.ca> wrote:
>
>
> Take a look at: http://www.icp-vortex.com/english/index_e.htm
>
> They have always made good RAID controllers.
I'll give a huge thumbs up for the ICPs, and also make sure you get the BBU
cache as well (batter back-up) otherwise TURN OFF YOUR WRITE CACHE ON THE
CARD. You will hose your database severely if you don't the one time hte
machine acidentally loses power.
I'm getting ready to put together a pretty beefy server with either an LSI
or ICP card (we're discussing options at this point) -- I've had really
good experience with the all of the ICP cards we've used. LSI used to be
worthless, couldn't do anything online at all in any form of *nix, but
atleast in Linux you can now, I don't know about FreeBSD, look into that,
drives fail, and it bites to have to take your server down, and leave it
down for a rebuild.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL
2006-07-05 23:46 suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
2006-07-06 00:52 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood <markir@paradise.net.nz>
2006-07-06 18:10 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
@ 2006-07-06 22:51 ` Mark Kirkwood <markir@paradise.net.nz>
2 siblings, 0 replies; 9+ messages in thread
From: Mark Kirkwood @ 2006-07-06 22:51 UTC (permalink / raw)
To: Kenji Morishige <kenjim@juniper.net>; +Cc: pgsql-performance
Kenji Morishige wrote:
> Thanks for the suggestion Mark, though the server chassis I am trying to
> utilize already has 4 10,000 RPM SCSI drives with SCA interfaces. Ideally I
> would like to use the existing drives and chassis and find another SCSI RAID
> controller. It looks like 3Ware only makes ATA controllers.
>
I should have checked that the 2200S was a *SCSI* RAID controller, sorry!
Cheers
Mark
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
2006-07-05 23:46 suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
@ 2006-07-10 14:52 ` Vivek Khera <vivek@khera.org>
1 sibling, 0 replies; 9+ messages in thread
From: Vivek Khera @ 2006-07-10 14:52 UTC (permalink / raw)
To: Kenji Morishige <kenjim@juniper.net>; +Cc: pgsql-performance
On Jul 5, 2006, at 7:46 PM, Kenji Morishige wrote:
> like to know what an ideal RAID controller that would be compatible
> with
> FreeBSD 6.1 would be these days.
LSI MegaRAID 320-2X and put half disks on one channel, half on the
other, and MIRROR+STRIPE them (ie, RAID10).
There is nothing faster for FreeBSD 6.
Just make sure you don't buy a Sun Fire X4100 to put it in, as it
will not fit :-(
Attachments:
smime.p7s (application/pkcs7-signature, 2.5K) download
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: suggested RAID controller for FreeBSD 6.1 +
@ 2006-07-07 13:57 Ron Peacetree <rjpeace@earthlink.net>
0 siblings, 0 replies; 9+ messages in thread
From: Ron Peacetree @ 2006-07-07 13:57 UTC (permalink / raw)
To: pgsql-performance
Adaptecs RAID controllers as all underwhelming.
The best commodity RAID controllers in terms of performance, size of available BBC, connectivity technologies (all of IDE, SCSI, SATA and FC are supported), etc are made by Areca.
Get one of Areca's RAID controllers that hold up to 2 GB of BBC.
ARC-11xx are the PCI-X based products.
ARC-12xx are the PCI-E based products.
Reviews at places like tweakers.net
Areca is based in Taiwan, but has European and US offices as well
Ron Peacetree
-----Original Message-----
>From: Kenji Morishige <kenjim@juniper.net>
>Sent: Jul 5, 2006 7:46 PM
>To: pgsql-performance@postgresql.org
>Cc: kenjim@juniper.net
>Subject: [PERFORM] suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
>
>I am currently running FreeBSD 4.11 (due to IT requirements for now) and
>Adaptec's 2200S RAID controller running in RAID5. I was advised in the past
>that the 2200S is actually a poor performing controller and obviously the
>RAID5 is less than ideal for databases. I chose to run the controller in
>RAID5 as the tech I talked to suggested that the 2200S was primarily designed
>for RAID5 and it would operate the best that way. My server is a dual Xeon
> 3.06Ghz box running on a motherboard approximately 2-3 years old now. I'd
>like to know what an ideal RAID controller that would be compatible with
>FreeBSD 6.1 would be these days.
>
>Thanks in advance,
>Kenji
>
>---------------------------(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
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2006-07-10 14:52 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-05 23:46 suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 Kenji Morishige <kenjim@juniper.net>
2006-07-06 00:52 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood <markir@paradise.net.nz>
2006-07-06 18:10 ` Kenji Morishige <kenjim@juniper.net>
2006-07-06 18:17 ` Re: suggested RAID controller for FreeBSD 6.1 + Scott Marlowe <smarlowe@g2switchworks.com>
2006-07-06 18:21 ` Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL 8.1 Paul Khavkine <paul.khavkine@distributel.ca>
2006-07-07 05:08 ` Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL Michael Loftis <mloftis@wgops.com>
2006-07-06 22:51 ` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL Mark Kirkwood <markir@paradise.net.nz>
2006-07-10 14:52 ` Vivek Khera <vivek@khera.org>
2006-07-07 13:57 Re: suggested RAID controller for FreeBSD 6.1 + Ron Peacetree <rjpeace@earthlink.net>
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