Re: implementing query timeout - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: implementing query timeout
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: implementing query timeout  ("Nicolas Bazin" <[email protected]>)
List pgsql-patches
Nicolas Bazin wrote:
> The INFORMIX equivalent is SET LOCK MODE TO WAIT [timeout value in seconds];
> If you don't specify any timeout value, you wait until all statements are
> completed, If timeout value is set to 0 then you return immediatly if the
> tables you query are already locked, ...
>
> This statement is valid for a connection or until another identical
> statement is sent.

Users want a more general timeout facitily, for example, queries taking
 > 10 minutes.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  [email protected]               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-patches by date:

Previous
From: "Nicolas Bazin"
Date:
Subject: Re: implementing query timeout
Next
From: Jan Wieck
Date:
Subject: Re: implementing query timeout