Re: bad performance on irix - Mailing list pgsql-hackers

From Robert E. Bruccoleri
Subject Re: bad performance on irix
Date
Msg-id 200203131319.IAA34542@stone.congenomics.com
Whole thread Raw
In response to Re: bad performance on irix  ("Luis Alberto Amigo Navarro" <lamigo@atc.unican.es>)
List 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 by date:

Previous
From: "Luis Alberto Amigo Navarro"
Date:
Subject: Re: bad performance on irix
Next
From: "Dalibor Andzakovic"
Date:
Subject: Re: Drop in performance for each INSERT/DELETE combo