| 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
| 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 |
| 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 |