Hi!
I asked same thing in the list formerly,
http://archives.postgresql.org/pgsql-general/2011-06/msg00888.php
And because of lack of answers now I asked here also:
http://stackoverflow.com/questions/6534654/postgresql-session-timeout
I'm very wondering that I don't (and can't) found a system variable
that define the timeout of the client session. Maybe I'm a real lama,
or search with wrong terms... :-)
The manual often refers to "Session end" - when the resources
released, but never I saw a section that describe when it happens.
The RDBMS-s needs some rule to mark a Session inactive or/and dead.
Commonly they are uses a "Timeout" parameter that control how many
minutes has ellapsed to session marked as Dead.
FireBird and ElevateDB do this too. If the client is do anything, this
time period extends again.
The cleanup is needed for remove the locks, unfinished (limbo or
started) transactions, and decrease the deadlock, or lock situations;
and to never reach the maximum connections.
So: is anybody here that can tell me how this working in PGSQL?
And if there is no control, when the Session ends?
Practical example (real):
A client program died on a transaction, and it leaves many locks in
the DataBase.
If Session Timeout is 5 minutes, then we can tell the other users who
got "Row lock", or "Transaction Timeout" errors to wait 6-7 minutes
and then trying again, because after 5 minutes the problematic session
is cleaned up, and locks/transactions removed from the objects.
Thanks for your help:
dd