[OGo-Users] postgres connection limit exceeded

[Andreas 'ads' Scherbaum]

On Sat, 01 Mar 2008 07:47:01 +0100 Sebastian Reitenbach wrote:

> Then, with my 200 maximum connections configured in postgres, this is by far 
> not enough. So I assume I should raise it to something like 3000 to be safe.

Seems like you have too much memory, or? ;-)

Your OS has to schedule 3000 processes (more, this 3k is just
PostgreSQL). Each backend needs some memory plus you need a lot shared
mem for managing all the backends and the data. Can't say a number here
but with 3000 running processes you will have some trouble anyway.


Bye

-- 
				Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors