Re: [GENERAL] postgres generates too much processes per minute

On Thu, Jun 19, 2008 at 8:17 AM, Bill Moran
<wmoran@collaborativefusion.com> wrote:
> 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.

You might consider using a connection pooler as well. The point of
such a thing is to allow applications requiring lots of connections to
share a smaller set of real connections to the database by proxying
connections. Look for pgBouncer and pgPool as example connection
pooling applications

- Josh / eggyknap

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general