From: Dave Cramer <pg@fastcrypt.com>
To: Luke Lonergan <LLonergan@greenplum.com>
Cc: Adam Weisberg <Aweisberg@seiu1199.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware/OS recommendations for large databases (
Date: Tue, 15 Nov 2005 09:15:04 -0500
Message-ID: <B41A9E46-AC4F-4A3A-B383-AB70091745CF@fastcrypt.com> (raw)
In-Reply-To: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com>
References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com>
Luke,
Have you tried the areca cards, they are slightly faster yet.
Dave
On 15-Nov-05, at 7:09 AM, Luke Lonergan wrote:
>
> I agree - you can get a very good one from www.acmemicro.com or
> www.rackable.com with 8x 400GB SATA disks and the new 3Ware 9550SX
> SATA
> RAID controller for about $6K with two Opteron 272 CPUs and 8GB of RAM
> on a Tyan 2882 motherboard. We get about 400MB/s sustained disk read
> performance on these (with tuning) on Linux using the xfs filesystem,
> which is one of the most critical factors for large databases.
>
> Note that you want to have your DBMS use all of the CPU and disk
> channel
> bandwidth you have on each query, which takes a parallel database like
> Bizgres MPP to achieve.
>
> Regards,
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: pg@fastcrypt.com, LLonergan@greenplum.com, Aweisberg@seiu1199.org
Subject: Re: Hardware/OS recommendations for large databases (
In-Reply-To: <B41A9E46-AC4F-4A3A-B383-AB70091745CF@fastcrypt.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