very large db performance question

From: LIANHE SHAO <lshao2(at)jhmi(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: very large db performance question
Date: 2003-11-26 20:22:01
Message-ID: 4cbacd4cb3c2.4cb3c24cbacd@jhmimail.jhmi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello All,
We will have a very large database to store
microarray data (may exceed 80-100G some day). now
we have 1G RAM, 2G Hz Pentium 4, 1 CPU. and enough
hard disk.

I never touched such large database before. I ask
several dbas if the hardware is ok, some said it is
ok for the query, but I am not so convinced. Because
I check the mailing list and learned that it is not
unreasonable to take several minutes to do the
query. But I want to query to be as fast as possible.

Could anybody tell me that our hardware is an issue
or not? do we really need better hardware to make
real difference?

Regards,
William

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Roger Ging 2003-11-26 21:29:16 Re: Followup - expression (functional) index use in joins
Previous Message Jeremiah Jahn 2003-11-26 20:14:11 cross table indexes or something?