pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Idle processes won't die
3+ messages / 3 participants
[nested] [flat]

* Idle processes won't die
@ 2004-02-24 22:50 James Taylor <jtx@hatesville.com>
  2004-02-24 23:56 ` Re: Idle processes won't die Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-25 01:30 ` Re: Idle processes won't die Rajesh Kumar Mallah <mallah@trade-india.com>
  0 siblings, 2 replies; 3+ messages in thread

From: James Taylor @ 2004-02-24 22:50 UTC (permalink / raw)
  To: 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?




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Idle processes won't die
  2004-02-24 22:50 Idle processes won't die James Taylor <jtx@hatesville.com>
@ 2004-02-24 23:56 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-02-24 23:56 UTC (permalink / raw)
  To: James Taylor <jtx@hatesville.com>; +Cc: pgsql-admin

James Taylor <jtx@hatesville.com> writes:
> 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,

In that case, Perl is *not* closing the connection.  Better check your
client library again ... it probably thinks it's supposed to recycle
the connections via a connection pool.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Idle processes won't die
  2004-02-24 22:50 Idle processes won't die James Taylor <jtx@hatesville.com>
@ 2004-02-25 01:30 ` Rajesh Kumar Mallah <mallah@trade-india.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Rajesh Kumar Mallah @ 2004-02-25 01:30 UTC (permalink / raw)
  To: James Taylor <jtx@hatesville.com>; +Cc: pgsql-admin


Dear James,

We have been using mod_perl with PostgreSQL in web environment
without any problems. I hope you are already using Apache::DBI for
connection pooling.

Regds
Mallah

James Taylor wrote:

> 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?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-02-25 01:30 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-24 22:50 Idle processes won't die James Taylor <jtx@hatesville.com>
2004-02-24 23:56 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-02-25 01:30 ` Rajesh Kumar Mallah <mallah@trade-india.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox