Re: Cannot restart postgresql when increasing max_connections - Mailing list pgsql-general

From Richard Huxton
Subject Re: Cannot restart postgresql when increasing max_connections
Date
Msg-id 4965EF93.5010701@archonet.com
Whole thread Raw
In response to Re: Cannot restart postgresql when increasing max_connections  ("Thom Brown" <thombrown@gmail.com>)
Responses Re: Cannot restart postgresql when increasing max_connections
List pgsql-general
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

pgsql-general by date:

Previous
From: Christian Schröder
Date:
Subject: Re: SPI_ERROR_CONNECT in plperl function
Next
From: "Thom Brown"
Date:
Subject: Re: Cannot restart postgresql when increasing max_connections