Re: URGENT: Performance tuning

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: URGENT: Performance tuning
Дата
Msg-id Pine.NEB.4.43.0206231444550.542-100000@angelic.cynic.net
обсуждение исходный текст
Ответ на Re: URGENT: Performance tuning  (Peter Dimov <jquest_j@yahoo.com>)
Ответы Re: URGENT: Performance tuning  (Peter Dimov <jquest_j@yahoo.com>)
Список pgsql-general
On Sat, 22 Jun 2002, Peter Dimov wrote:

> First I tested with P II 400 MHz 256 MB RAM.
> And second Dual Athlon MP , 1.6 GHz , 1 or 2 GB RAM.
> I expected to get big advantage from the second system and
> was very supprise from the results : I wan only 30 - 40% faster as the first.

Well, did you analyze your load carefully? How much of your
application is CPU-bound, and how much is disk I/O bound? How much
memory do you need to cache the working set, if it can be cached
at all?

Disks are often very important for database work, far more so than
CPU or memory. I have an application with queries that run about
the same on a 600 MHz Pentium III and a dual 2 GHz Xeon system, if
you use the same disks.

> I think the mistake is by tuning....

Very likely.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


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

Предыдущее
От: Peter Dimov
Дата:
Сообщение: Re: URGENT: Performance tuning
Следующее
От: Peter Dimov
Дата:
Сообщение: Re: URGENT: Performance tuning