[OT]Physical sites handling large data

Hi all,

One of my friends is evaluating postgres for large databases. This is a select
intensive application which is something similar to data-warehousing as far as
I can see.

The data is 150GB in flat files so would swell to 200GB+ with indexes.

Is anybody running that kind of site? Any url? Any performance numbers/tuning
tips for random selects?

I would hate to put mysql there but we are evaluating that too. I would hate if
postgres loses this to mysql because I didn't know few things about postgres.

Secondly would it make a difference if I host that database on say, an HP-UX
box? From some tests I have done for my job, single CPU HP-UX box trounces 4
way xeon box. Any suggestions in this directions?

TIA..

Bye
Shridhar

--
Quality Control, n.: The process of testing one out of every 1,000 units coming
off a production line to make sure that at least one out of 100 works.