Re: Cannot restart postgresql when increasing max_connections

["Thom Brown" <thombrown@xxxxxxxxx>]

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@xxxxxxxxxxxx>

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