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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]