Re: bad performance on irix

Поиск
Список
Период
Сортировка
От Robert E. Bruccoleri
Тема Re: bad performance on irix
Дата
Msg-id 200203131319.IAA34542@stone.congenomics.com
обсуждение исходный текст
Ответ на Re: bad performance on irix  ("Luis Alberto Amigo Navarro" <lamigo@atc.unican.es>)
Список pgsql-hackers
Dear Luis,
> 
> nbuf is set to 6653, here is a excerpt from par, thanks and regards

What kind of SGI are you using, and how much memory does it have?

I don't know what to make out of this par output. If this is from a running
Postgres, then it's waiting for a lock. Try the following:

echo where | dbx -p <pid>

where <pid> is for the Postgres backend.

--Bob

+-----------------------------+------------------------------------+
| Robert E. Bruccoleri, Ph.D. | email: bruc@acm.org                |
| P.O. Box 314                | URL:   http://www.congen.com/~bruc |
| Pennington, NJ 08534        |                                    |
+-----------------------------+------------------------------------+


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

Предыдущее
От: "Luis Alberto Amigo Navarro"
Дата:
Сообщение: Re: bad performance on irix
Следующее
От: "Dalibor Andzakovic"
Дата:
Сообщение: Re: Drop in performance for each INSERT/DELETE combo