Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver.

Поиск
Список
Период
Сортировка
От eleven@ludojad.itpp.pl
Тема Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver.
Дата
Msg-id 20040629175227.GA11658@ludojad.itpp.pl
обсуждение исходный текст
Ответ на Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver.  (Marc <identd@gmail.com>)
Ответы Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver.
Список pgsql-performance
On Tue, Jun 29, 2004 at 09:17:36AM -0700, Marc wrote:

> > Performance issue, I'm experiencing here, is somewhat
> > weird - server gets high average load (from 5 up to 15,
> > 8 on average). Standard performance monitoring
> > utilities (like top) show that CPUs are not loaded
> > (below 20%, often near zero).
> So ... you never actually say what the performance issue you
> experience is.  Having a high load average is not necessarily a
> performance issue.

Well, if the server's CPUs are idle and the machine
is starting to hog itself, one can
suspect something bad going on.

> What is it that you want to fix?

Basically, I'm wondering if I'm already on the edge of
performance capabilities of this machine/configuration, or maybe
there's some abnormal behaviour happening (which
could be noticed by somebody from this mailing list, hopefully).

In particular - could someone tell me if those iostat
values can tell if I'm close to upper performance boundary
of fast SCSI (Ultra 320, 15k RPM) disks?

--
11.

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

Предыдущее
От: "Mohan A"
Дата:
Сообщение: suggestions to improve performace
Следующее
От: "Harald Lau (Sector-X)"
Дата:
Сообщение: Re: no index-usage on aggregate-functions?