Re: Re: [NOVICE] Re: re : PHP and persistent connections

"Ross J. Reedstrom" <reedstrm(at)rice(dot)edu> writes:
> Which brings us back around to the point of why this is on Hackers:
> PostgreSQL currently has no clean method for dropping idle connections.
> Yes, some apps handle this themselves, but not all. A number of people
> seem to feel there is a need for this feature.

I'm still not following exactly what people think would happen if we did
have such a "feature". OK, the backend times out after some interval
of seeing no activity, and disconnects. How is the client going to
react to that, exactly, and why would it not conclude that something's
gone fatally wrong with the database?

Seems to me that you still end up having to fix the client, and that
in the last analysis this is a client issue, not something for the
backend to hack around.

regards, tom lane