very large db performance question - Mailing list pgsql-performance

From LIANHE SHAO
Subject very large db performance question
Date
Msg-id 4cbacd4cb3c2.4cb3c24cbacd@jhmimail.jhmi.edu
Whole thread Raw
Responses Re: very large db performance question
List 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


pgsql-performance by date:

Previous
From: Jeremiah Jahn
Date:
Subject: cross table indexes or something?
Next
From: Roger Ging
Date:
Subject: Re: Followup - expression (functional) index use in joins