Re: [SQL] postgres timeout.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stef <svb(at)ucs(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] postgres timeout.
Date: 2004-01-28 16:49:12
Message-ID: 20369.1075308552@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-sql

Stef <svb(at)ucs(dot)co(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message markw 2004-01-28 18:36:39 Re: High Performance/High Reliability File system on
Previous Message Bill Moran 2004-01-28 16:02:21 Re: On the performance of views

Browse pgsql-sql by date

  From Date Subject
Next Message Samuel Tardieu 2004-01-28 17:58:53 Question about isolation
Previous Message Bill Moran 2004-01-28 16:02:21 Re: On the performance of views