What's the best hardver for PostgreSQL 8.1?

Поиск
Список
Период
Сортировка
От Antal Attila
Тема What's the best hardver for PostgreSQL 8.1?
Дата
Msg-id 43A84D03.7090002@ritek.hu
обсуждение исходный текст
Ответы Re: What's the best hardver for PostgreSQL 8.1?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: What's the best hardver for PostgreSQL 8.1?  (Vivek Khera <vivek@khera.org>)
Список pgsql-performance
Hi!

What do you suggest for the next problem?
We have complex databases with some 100million rows (2-3million new
records per month). Our current servers are working on low resposibility
in these days, so we have to buy new hardver for database server. Some
weeks ago we started to work with PostgreSQL8.1, which solved the
problem for some months.
There are some massive, hard query execution, which are too slow (5-10
or more minutes). The parallel processing is infrequent (rarely max. 4-5
parallel query execution).
So we need high performance in query execution with medium parallel
processability.
What's your opinion what productions could help us? What is the best or
only better choice?
The budget line is about 30 000$ - 40 000$.

Regards, Atesz

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: PostgreSQL and Ultrasparc T1
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Overriding the optimizer