Hardware/OS recommendations for large databases (5TB)

From: "Adam Weisberg" <Aweisberg(at)seiu1199(dot)org>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Hardware/OS recommendations for large databases (5TB)
Date: 2005-11-14 23:46:41
Message-ID: 1B80C974ABFB23429A403B6667FE84C71066E8@seiumain.SEIU.local
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?

The data is for analysis, so there is virtually no inserting besides a
big bulk load. Analysis involves full-database aggregations - mostly
basic arithmetic and grouping. In addition, much smaller subsets of data
would be pulled and stored to separate databases.

I have been working with datasets no bigger than around 30GB, and that
(I'm afraid to admit) has been in MSSQL.

Thanks,

Adam

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2005-11-14 23:51:09 Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian??
Previous Message Tom Lane 2005-11-14 23:42:43 Re: Help speeding up delete