pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@qwest.net>
To: bsimon@loxane.com
Cc: pgsql-performance@postgresql.org
Subject: Re: NAS, SAN or any alternate solution ?
Date: Tue, 20 Jul 2004 02:20:56 -0600
Message-ID: <1090311656.709.14.camel@localhost.localdomain> (raw)
In-Reply-To: <OF87F30D92.9973FC60-ONC1256ED7.0029C226-C1256ED7.002B6957@beauchamp.loxane.fr>
References: <OF87F30D92.9973FC60-ONC1256ED7.0029C226-C1256ED7.002B6957@beauchamp.loxane.fr>

On Tue, 2004-07-20 at 01:52, bsimon@loxane.com wrote:
> Hi all,
> 
> I've been searching the list for a while but couldn't find any
> up-to-date information relating to my problem.
> We have a production server with postgresql on cygwin that currently
> deels with about 200 Gigs of data (1 big IDE drive). We plan to move
> to linux for some reasons I don't have to explain.
> Our aim is also to be able to increase our storage capacity up to
> approximately 1 or 2 terabytes and to speed up our production process.
> As we are a small "microsoft addicted" company , we have some
> difficulties to choose the best configuration that would best meet our
> needs.
> Our production process is based on transaction (mostly huge inserts)
> and disk access is the main bottlle-neck.
> 
> Our main concern is hardware related :
> 
> Would NAS or SAN be good solutions ? (I've read that NAS uses NFS
> which could slow down the transfer rate ??)
> Has anyone ever tried one of these with postgresql ? 

Your best bet would likely be a large external RAID system with lots o
cache.  Next would be a fast internal RAID card like the LSI Megaraid
cards, with lots of drives and batter backed cache.  Next would be a
SAN, but be careful, there may be issues with some cards and their
drivers under linux, research them well before deciding.  NFS is right
out if you want good performance AND reliability.

The cheapest solution that is likely to meet your needs would be the
internal RAID card with battery backed cache.  




view thread (9+ messages)  latest in thread

Message-ID: <1090311656.709.14.camel@localhost.localdomain>
Permalink:  ../1090311656.709.14.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1090311656.709.14.camel@localhost.localdomain

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: smarlowe@qwest.net, bsimon@loxane.com
  Subject: Re: NAS, SAN or any alternate solution ?
  In-Reply-To: <1090311656.709.14.camel@localhost.localdomain>

* 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