On Thu, Jun 19, 2008 at 8:17 AM, Bill Moran
<[EMAIL PROTECTED]> wrote:
> In response to "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:
>
>> 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

Reply via email to