Search Postgresql Archives

Re: postgres generates too much processes per minute

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In response to "coliban@xxxxxxxxx" <coliban@xxxxxxxxx>:

> 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@xxxxxxxxxxxxxxxxxxxxxxx
Phone: 412-422-3463x4023


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux