Postgres Pro
Downloads
Home   >   mailing lists

Re: deadlock with vacuum full on 7.4.5 - Mailing list pgsql-general

From Tom Lane
Subject Re: deadlock with vacuum full on 7.4.5
Date
Msg-id 29681.1099367082@sss.pgh.pa.us
Whole thread Raw
In response to Re: deadlock with vacuum full on 7.4.5  (jks@selectacast.net)
List pgsql-general
Tree view 
jks@selectacast.net writes:
> So why isn't the AccessShareLock dropped as soon as the SELECT is over?

In general, locks are held till transaction commit.  See any basic
database text for the reasons why this is a good idea.

            regards, tom lane

pgsql-general by date:

Previous
From: jks@selectacast.net
Date:
Subject: Re: deadlock with vacuum full on 7.4.5
Next
From: Randall Smith
Date:
Subject: Re: oracle synchronization strategy