From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | [OT]Physical sites handling large data |
Date: | 2002-09-13 11:04:51 |
Message-ID: | 3D8213AB.11155.9994FC7@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephane Bortzmeyer | 2002-09-13 12:06:01 | Re: An opportunity to prove PostgreSQL and our requirement of Case Study info [EUreg #11] |
Previous Message | Deepa | 2002-09-13 10:50:56 | database connectivty problem! |
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2002-09-13 11:27:17 | Re: Multicolumn foreign keys need useless unique indices? |
Previous Message | Zeugswetter Andreas SB SD | 2002-09-13 10:43:33 | Re: |