From: Simon Riggs <simon@2ndquadrant.com>
To: Konstantin Pelepelin <checat@pochtamt.ru>
Cc: mike@thegodshalls.com
Cc: pgsql-admin@postgresql.org
Subject: Re: are there ways for 'idle timeout'?
Date: Tue, 13 Jul 2004 11:31:37 +0100
Message-ID: <1089714696.17493.2448.camel@stromboli> (raw)
In-Reply-To: <200407121326.41770.checat@pochtamt.ru>
References: <opsavj6izuhocrah@cathost.of.dtf.ru>
<1089430151.10763.17.camel@localhost.localdomain>
<200407121326.41770.checat@pochtamt.ru>
On Mon, 2004-07-12 at 10:26, Konstantin Pelepelin wrote:
> The
> > > best solution I see is having an (per session)
> > > idle_transaction_timeout or idle_connection_timeout
> > > setting. But there is no such thing in postgres!
> > > Scanning through list I've not found any workaround.
Have you looked at statement_timeout?
This doesn't do exactly what you want, but is close enough.
If you don't have it at your release, upgrade.
> > Looking into TODO I don't see any plans for it.
> > > Is it too difficult implementing or I've missed
> > > something or are there workarounds?
This might be something you could do...
Best regards, Simon Riggs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: simon@2ndquadrant.com, checat@pochtamt.ru, mike@thegodshalls.com
Subject: Re: are there ways for 'idle timeout'?
In-Reply-To: <1089714696.17493.2448.camel@stromboli>
References: <opsavj6izuhocrah@cathost.of.dtf.ru> <1089430151.10763.17.camel@localhost.localdomain> <200407121326.41770.checat@pochtamt.ru> <1089714696.17493.2448.camel@stromboli>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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