very large db performance question

Поиск
Список
Период
Сортировка
От LIANHE SHAO
Тема very large db performance question
Дата
Msg-id 4cbacd4cb3c2.4cb3c24cbacd@jhmimail.jhmi.edu
обсуждение исходный текст
Ответы Re: very large db performance question  (Neil Conway <neilc@samurai.com>)
Список 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 по дате отправления:

Предыдущее
От: Jeremiah Jahn
Дата:
Сообщение: cross table indexes or something?
Следующее
От: Roger Ging
Дата:
Сообщение: Re: Followup - expression (functional) index use in joins