Skip site navigation (1) Skip section navigation (2)

Idle processes won't die

From: James Taylor <jtx(at)hatesville(dot)com>
To: 'pgsql-admin(at)postgresql(dot)org' <pgsql-admin(at)postgresql(dot)org>
Subject: Idle processes won't die
Date: 2004-02-24 22:50:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi everyone, using mod_perl with Postgres, postgres is on the same 
server as the webserver.  Perl is opening connections, and then closing 
them at the end of every script, however Pg
is refusing to close the connection, and I have tons and tons of Idle 
processes sitting around, which causes the web site to crash because 
the maximum number of pgsql processes gets reached after the site is 
accessed 32 times.  From everything I know about Perl, even if I didn't 
implicitly close the database handles, the perl garbage handler would 
close them for me.  Is there some sort of configuration for postgres to 
disallow all these idle processes from sticking around, so they 
maybe... close themselves after 5 seconds or something similar?


pgsql-admin by date

Next:From: Tom LaneDate: 2004-02-24 23:56:55
Subject: Re: Idle processes won't die
Previous:From: John AllgoodDate: 2004-02-24 21:23:54

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group