Re: Cannot restart postgresql when increasing max_connections

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Cannot restart postgresql when increasing max_connections
Дата
Msg-id 4965EF93.5010701@archonet.com
обсуждение исходный текст
Ответ на Re: Cannot restart postgresql when increasing max_connections  ("Thom Brown" <thombrown@gmail.com>)
Ответы Re: Cannot restart postgresql when increasing max_connections
Список 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 по дате отправления:

Предыдущее
От: Christian Schröder
Дата:
Сообщение: Re: SPI_ERROR_CONNECT in plperl function
Следующее
От: "Thom Brown"
Дата:
Сообщение: Re: Cannot restart postgresql when increasing max_connections