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. [SOLVED]
Date: Wed, 28 Jan 2004 12:47:22 +0200
Message-ID: <20040128124722.78fe5dc0.svb@ucs.co.za> (raw)
In-Reply-To: <20040128121217.2e4aceef.svb@ucs.co.za>
References: <20040128121109.02f554e6.svb@ucs.co.za>
<20040128121217.2e4aceef.svb@ucs.co.za>
Hi all,
It seems I always find a solution just after
panicking a little bit.
Anyway, I found that statement_timeout solved
my problem. When I tested it earlier, I actually
made an error, and skipped it as a possible
solution.
Cheers
Stef
Stef mentioned :
=> 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. [SOLVED]
In-Reply-To: <20040128124722.78fe5dc0.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