Hardware suggestions for a new data warehouse Postgresql/Bizgres server? (6000)

From: "Filip Wuytack" <fwuytack(at)fgscapital(dot)com>
To: <bizgres-general(at)pgfoundry(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Hardware suggestions for a new data warehouse Postgresql/Bizgres server? (6000)
Date: 2005-07-26 11:35:39
Message-ID: 20050726113544.E480A52EEE@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I've been lurking at both the bizgres and postgres mailing lists in recent
months to get some ideas for building a new db server. I saw some threads on
the 7k$ server and it sounds like the Opteron, lots of ram and raid10 is the
way to go. (my budget is +/- 6000 (=$10000))

But I'm keen to get some specific input on the more data warehouse type of
db requirements. The db will hold some 1000 tables (multiple schemas, 1 db)
with some of the larger tables going over 50m rows (and expect them to grow
another 10m/year). This is mainly all financial/statistical data. I only
have a small number of people working against the db (10 people plus maybe
another 20 applications running batch jobs) but they crunch through lots of
data (the bigger tables or views unioning big datasets). I'm also keen to
make use of PL/R inside Postgresql, so I presume this might put extra
requirements on the CPU side of things.

I would be very keen to hear what you would suggest for this setup or what
experiences you have to share.

Btw, I would buy to hardware for the UK, so any good retailers you know of,
let me know.

Many thanks,

Filip

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-07-26 13:14:22 Re: Trigger disactivation and SELECT WAITING
Previous Message Riyad Aufari 2005-07-26 10:46:52 Error when entering template1