From: Stef <svb@ucs.co.za>
To: pg-perform <pgsql-performance@postgresql.org>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: postgres timeout.
Date: Wed, 28 Jan 2004 12:12:17 +0200
Message-ID: <20040128121217.2e4aceef.svb@ucs.co.za> (raw)
In-Reply-To: <20040128121109.02f554e6.svb@ucs.co.za>
References: <20040128121109.02f554e6.svb@ucs.co.za>
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
=>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: svb@ucs.co.za, pgsql-performance@postgresql.org
Subject: Re: postgres timeout.
In-Reply-To: <20040128121217.2e4aceef.svb@ucs.co.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox