From: Claus Guttesen <kometen@gmail.com>
To: Adam Weisberg <Aweisberg@seiu1199.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware/OS recommendations for large databases (5TB)
Date: Tue, 15 Nov 2005 09:28:30 +0100
Message-ID: <b41c75520511150028o553e6bb5j@mail.gmail.com> (raw)
In-Reply-To: <1B80C974ABFB23429A403B6667FE84C71066E8@seiumain.SEIU.local>
References: <1B80C974ABFB23429A403B6667FE84C71066E8@seiumain.SEIU.local>
> Does anyone have recommendations for hardware and/or OS to work with around
> 5TB datasets?
Hardware-wise I'd say dual core opterons. One dual-core-opteron
performs better than two single-core at the same speed. Tyan makes
some boards that have four sockets, thereby giving you 8 cpu's (if you
need that many). Sun and HP also makes nice hardware although the Tyan
board is more competetive priced.
OS wise I would choose the FreeBSD amd64 port but partititions larger
than 2 TB needs some special care, using gpt rather than disklabel
etc., tools like fsck may not be able to completely check partitions
larger than 2 TB. Linux or Solaris with either LVM or Veritas FS
sounds like candidates.
> I have been working with datasets no bigger than around 30GB, and that (I'm
> afraid to admit) has been in MSSQL.
Well, our data are just below 30 GB so I can't help you there :-)
regards
Claus
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: kometen@gmail.com, Aweisberg@seiu1199.org
Subject: Re: Hardware/OS recommendations for large databases (5TB)
In-Reply-To: <b41c75520511150028o553e6bb5j@mail.gmail.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