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

Re: insert waiting

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
Cc: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: insert waiting
Date: 2004-08-20 13:18:22
Message-ID: 20040820131822.GD20737@wolff.to (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Aug 20, 2004 at 13:20:49 +0200,
  Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se> wrote:
> Hi John,
> 
> but how long is the exclusive lock taken? For the whole transaction?
> My jobs are quite big, and transactions usually take several minutes.
> I can not afford have all my other jobs stalled for that time.

Once a lock is taken by a transaction, it is held until the end of that
transaction.

In response to

pgsql-general by date

Next:From: Bruno Wolff IIIDate: 2004-08-20 13:20:29
Subject: Re: 7.4.5 release
Previous:From: Bruno Wolff IIIDate: 2004-08-20 12:59:56
Subject: Re: libpq: passwords WAS: scripting & psql issues

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