Re: postgres generates too much processes per minute - Mailing list pgsql-general

From Bill Moran
Subject Re: postgres generates too much processes per minute
Date
Msg-id 20080619101710.dba7192e.wmoran@collaborativefusion.com
Whole thread Raw
In response to postgres generates too much processes per minute  ("coliban@gmail.com" <coliban@gmail.com>)
Responses Re: postgres generates too much processes per minute  ("Josh Tolley" <eggyknap@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Vacuum and inserts
Next
From: Bill Moran
Date:
Subject: Re: Vacuum and inserts