Closing idle connections

From: Steve Lane <slane(at)fmpro(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Closing idle connections
Date: 2002-03-15 00:38:56
Message-ID: B8B69EC0.A15A%slane@fmpro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can someone tell me the easiest way to have the postmaster shut down idle
connections after some period of time? Or is this even the right way to
think about it?

I'm using Postgres as a back end with PHP/Apache in the middle. The server
keeps bogging down because apache doesn't seem to reuse old processes with
their connections very well -- the number of open connections keeps growing
until postmaster refuses any new ones.

Do I just need a way of shutting down the idle connections? Or is there
something else I'm missing?

-- sgl

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Hallstrom 2002-03-15 01:22:14 Re: Closing idle connections
Previous Message Carlo Florendo 2002-03-15 00:30:56 RPM vs. Source