diff options
| author | Robert Haas | 2016-03-16 15:30:45 +0000 |
|---|---|---|
| committer | Robert Haas | 2016-03-16 15:30:45 +0000 |
| commit | c6dda1f48e573cc60fe25d8d470a05bfabed0252 (patch) | |
| tree | 0c04e3abde478ad77e2237ec7211c71b9116c997 /doc | |
| parent | 5871b88487cfd07966e2ce08609a4d6d5ee9718e (diff) | |
Add idle_in_transaction_session_timeout.
Vik Fearing, reviewed by Stéphane Schildknecht and me, and revised
slightly by me.
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/src/sgml/config.sgml | 20 | ||||
| -rw-r--r-- | doc/src/sgml/mvcc.sgml | 4 |
2 files changed, 23 insertions, 1 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 6c73fb439cc..da971f5fca6 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -6063,6 +6063,26 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; </listitem> </varlistentry> + <varlistentry id="guc-idle-in-transaction-session-timeout" xreflabel="idle_in_transaction_session_timeout"> + <term><varname>idle_in_transaction_session_timeout</varname> (<type>integer</type>) + <indexterm> + <primary><varname>idle_in_transaction_session_timeout</> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Terminate any session with an open transaction that has been idle for + longer than the specified duration in milliseconds. This allows any + locks held by that session to be released and the connection slot to be reused; + it also allows tuples visible only to this transaction to be vacuumed. See + <xref linkend="routine-vacuuming"> for more details about this. + </para> + <para> + The default value of 0 disables this feature. + </para> + </listitem> + </varlistentry> + <varlistentry id="guc-vacuum-freeze-table-age" xreflabel="vacuum_freeze_table_age"> <term><varname>vacuum_freeze_table_age</varname> (<type>integer</type>) <indexterm> diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index dd3c7755309..6352e12ee1e 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -725,7 +725,9 @@ ERROR: could not serialize access due to read/write dependencies among transact <listitem> <para> Don't leave connections dangling <quote>idle in transaction</quote> - longer than necessary. + longer than necessary. The configuration parameter + <xref linkend="guc-idle-in-transaction-session-timeout"> may be used to + automatically disconnect lingering sessions. </para> </listitem> <listitem> |