Re: [SQL] postgres timeout. - Mailing list pgsql-performance

From Tom Lane
Subject Re: [SQL] postgres timeout.
Date
Msg-id 20369.1075308552@sss.pgh.pa.us
Whole thread Raw
In response to postgres timeout.  (Stef <svb@ucs.co.za>)
List pgsql-performance
Stef <svb@ucs.co.za> writes:
> I'm trying to find out if there is a specific setting
> to make transactions time out faster in a scenario
> where there's an update on a table in a transaction
> block, and another update process tries to update
> the same column.

> It looks like the second process will wait until you
> end the transaction block in the first transaction.

You can use statement_timeout to limit the wait.

            regards, tom lane

pgsql-performance by date:

Previous
From: Stef
Date:
Subject: postgres timeout.
Next
From: Stef
Date:
Subject: Re: postgres timeout. [SOLVED]