This database server is currently serving 3 very very busy multi-core web servers, and we're about to add another 3 to help deal with the load.
I'm afraid that upgrading is not an option at present because it's in production.
I've taken the suggestion of increasing shared buffers and now got max_connections set to 1500 and shared_buffers set to about a gigabyte.
I actually mentioned pgPool II to my boss earlier, and it's something we will have to seriously consider, but will have to do some research first.
Thanks
Thom
2009/1/8 Richard Huxton
<dev@archonet.com>Thom Brown wrote:
> It is running on 64-bit Gentoo 2.6.25.
>
> You might be right about needing to increase the shared buffers. Thanks for
> the suggestion. I'll have to give that a try
If shared_buffers was so small that you can't handle the connections you
might benefit from one of the links on this page.
http://wiki.postgresql.org/wiki/Performance_Optimization
Try the first one, that gives you a good overview.
Oh and if you're running a web-application consider connection pooling -
pgbouncer or pgpool.
Oh, and upgrade from 8.3.1 to the latest in the 8.3 series at your
earliest convenience.
http://www.postgresql.org/support/versioning
--
Richard Huxton
Archonet Ltd