Skip site navigation (1) Skip section navigation (2)

Re: postgres timeout.

From: Stef <svb(at)ucs(dot)co(dot)za>
To: pg-perform <pgsql-performance(at)postgresql(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org <pgsql-sql(at)postgresql(dot)org>
Subject: Re: postgres timeout.
Date: 2004-01-28 10:12:17
Message-ID: 20040128121217.2e4aceef.svb@ucs.co.za (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-sql
Forgot to mention that I use postgres 7.3.4

Stef mentioned :
=> Hi all ,
=> 
=> 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.
=> 
=> I've looked at the deadlock timeout parameter and
=> other parameters, but I don't think I found  what 
=> I'm looking for.
=> 
=> I basically need to be able to let the second process
=> exit with an error after waiting 5 - 10 seconds.
=> 
=> Please can someone help?
=> 
=> Kind Regards
=> Stefan
=> 

In response to

Responses

pgsql-performance by date

Next:From: StefDate: 2004-01-28 10:47:22
Subject: Re: postgres timeout. [SOLVED]
Previous:From: StefDate: 2004-01-28 10:11:09
Subject: postgres timeout.

pgsql-sql by date

Next:From: raingseyDate: 2004-01-28 10:12:19
Subject: Help! Error with postgresql!
Previous:From: StefDate: 2004-01-28 10:11:09
Subject: postgres timeout.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group