Postgres Pro
Downloads
Home   >   mailing lists

Hardware/OS recommendations for large databases (5TB) - Mailing list pgsql-performance

From Adam Weisberg
Subject Hardware/OS recommendations for large databases (5TB)
Date
Msg-id 1B80C974ABFB23429A403B6667FE84C71066E8@seiumain.SEIU.local
Whole thread Raw
Responses Re: Hardware/OS recommendations for large databases (5TB)  (Claus Guttesen <kometen@gmail.com>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Steve Wampler
Date:
Subject: Re: Help speeding up delete
Next
From: Steve Wampler
Date:
Subject: Re: Help speeding up delete