Re: bad performance on irix
Robert E. Bruccoleri <bruc@stone.congenomics.com>
From: "Robert E. Bruccoleri" <bruc@stone.congenomics.com>
To: lamigo@atc.unican.es (Luis Alberto Amigo Navarro)
Cc: bruc@acm.org, pgsql-hackers@postgresql.org
Date: 2002-03-13T16:04:35Z
Lists: 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 | | +-----------------------------+------------------------------------+