From: Greg Smith <greg@2ndquadrant.com>
To: chris <chricki@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware advice for scalable warehouse db
Date: Fri, 15 Jul 2011 08:10:37 +0100
Message-ID: <4E1FE7ED.90909@2ndquadrant.com> (raw)
In-Reply-To: <ivon1e$81d$1@dough.gmane.org>
References: <ivon1e$81d$1@dough.gmane.org>
chris wrote:
> My employer is a university with little funds and we have to find a
> cheap way to scale for the next 3 years, so the SAN seems a good chance
> to us.
A SAN is rarely ever the cheapest way to scale anything; you're paying
extra for reliability instead.
> I was thinking to put the WAL and the indexes on the local disks, and
> the rest on the SAN. If funds allow, we might downgrade the disks to
> SATA and add a 50 GB SATA SSD for the WAL (SAS/SATA mixup not possible).
>
If you want to keep the bulk of the data on the SAN, this is a
reasonable way to go, performance-wise. But be aware that losing the
WAL means your database is likely corrupted. That means that much of
the reliability benefit of the SAN is lost in this configuration.
> Any experiences with iSCSI vs. Fibre
> Channel for SANs and PostgreSQL? If the SAN setup sucks, do you see a
> cheap alternative how to connect as many as 16 x 2TB disks as DAS?
>
I've never heard anyone recommend iSCSI if you care at all about
performance, while FC works fine for this sort of job. The physical
dimensions of 3.5" drives makes getting 16 of them in one reasonably
sized enclosure normally just out of reach. But a Dell PowerVault
MD1000 will give you 15 x 2TB as inexpensively as possible in a single
3U space (well, as cheaply as you want to go--you might build your own
giant box cheaper but I wouldn't recommend ). I've tested MD1000,
MD1200, and MD1220 arrays before, and always gotten seriously good
performance relative to the dollars spent with that series. Only one of
these Dell storage arrays I've heard two disappointing results from (but
not tested directly yet) is the MD3220.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
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: greg@2ndquadrant.com, chricki@gmx.net
Subject: Re: Hardware advice for scalable warehouse db
In-Reply-To: <4E1FE7ED.90909@2ndquadrant.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