Re: Optimal values for 500 connections

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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

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

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