We have statement_timeout, but no transaction timeout. Does that help?
---------------------------------------------------------------------------
Eugene Strulyov wrote:
> Hi everybody,
>
> Our aplpication uses PostgreSQL for data store. We have a problem with the way
> long-running transactions are handled.
>
> Our application had a bug (from what I understand it went into an infinite
> loop). As a result, the transaction it was processing was neither committed
> nor rolled back. Because of that, the misbehaving process was left holding
> the locks and none of the other processes were able to do transactions.
>
> My question is, how do I get PostgreSQL to automatically abort transactions
> that take longer than a certain timeout?
>
> thanks in advance,
>
> Eugene
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073