Re: postgres generates too much processes per minute

In response to "coliban@gmail.com" <coliban@gmail.com>:

> Hello,
>
> i have the problem that postgres ist starting and stopping several (up
> to 4)  processes per minute, so that the error log in windows is
> running full, with more than 14 entries every minute.
>
> Does someone know, how to reduce the start and the end of so many
> processes, is there a variable or something ?

A process is started for every connection and ends when the connection
is closed.  If you're opening/closing connections frequently, you'll
see this.  It's by design.

Is the problem just that it's overwhelming the logs?  If so, you're
best bet is probably to reduce the amount of logging that occurs.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023