[OGo-Users] postgres connection limit exceeded

[Helge Hess]

On 07.03.2008, at 18:07, Andreas 'ads' Scherbaum wrote:
> We discussed that topic a bit on IRC yesterday and just raising the
> connection limit is not solving your problems at all. As example,
> with 1000 or 2000 running but idle processes your OS hat to schedule
> all this processes.


Scheduling 2000 processes is a no brainer for modern operating systems  
like Linux or BSD (my MacOS runs 400 threads just after I started ...).
And memory is no big issue with forked but IDLE PostgreSQL processes  
either (as you say, allmost all of it is shared memory and the big  
memory is the FS cache, which is shared anyways).

Unless you are running a REALLY big install, you won't get hurt by this.

All this is besides the point nevertheless ;-) I agree that the  
current OGo behaviour is unnecessary and suboptimal :-)

Greets,
   Helge
-- 
Helge Hess
http://www.helgehess.eu/