Re: Optimal values for 500 connections

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Optimal values for 500 connections
Дата
Msg-id 20090627195658.GO21081@fetter.org
обсуждение исходный текст
Ответ на Optimal values for 500 connections  (Pedro Doria Meunier <pdoria@netmadeira.com>)
Список pgsql-general
On Fri, Jun 26, 2009 at 07:52:43PM +0100, Pedro Doria Meunier wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all,
>
> I'm wondering what are the correct values in postgresql.conf for
> max_connections = 500 ...

You can either increase your shared memory settings or see about a
connection pooler such as pgbouncer.  The latter will be lighter on
your system at the cost of maintaining another component.

Cheers,
David.
>
> The values I had in 8.2.13 conf file worked without a problem but with
> the new 8.3.7 postmaster simply refuses to start.
>
> Any pointers would be highly appreciated ;-)
>
> BR,
>
> - --
> Pedro Doria Meunier
> GSM: +351 96 17 20 188
> Skype: pdoriam
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
>
> iD8DBQFKRRhy2FH5GXCfxAsRAt7KAJ0eiq6dcDyuvK5JpcfLb8atGd9FUACgo1TG
> G2dZFIB7BzU3bWcGBhikQaE=
> =YSCi
> -----END PGP SIGNATURE-----
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: pasting into psql garbles text
Следующее
От: Michal Szymanski
Дата:
Сообщение: Free OLAP software for Postgres databas