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

From Robert E. Bruccoleri
Subject Re: bad performance on irix
Date
Msg-id 200203131604.LAA36063@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,After looking at your system configuration, I would recommend
buying more RAM (it's very inexpensive for older systems like yours),
and then allocating much more buffer space for PostgreSQL. It will
have a profound effect on overall performance, although not for this
particular problem where lock contention is an issue.

+-----------------------------+------------------------------------+
| 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: mlw
Date:
Subject: Re: select max(column) not using index
Next
From: "Luis Alberto Amigo Navarro"
Date:
Subject: Re: again on bad performance