From: | Claus Guttesen <kometen(at)gmail(dot)com> |
---|---|
To: | Adam Weisberg <Aweisberg(at)seiu1199(dot)org> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Hardware/OS recommendations for large databases (5TB) |
Date: | 2005-11-15 08:28:30 |
Message-ID: | b41c75520511150028o553e6bb5j@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2005-11-15 08:47:37 | Re: Help speeding up delete |
Previous Message | Steve Wampler | 2005-11-15 04:03:56 | Re: Help speeding up delete |