Re: Idle in transaction ???? - Mailing list pgsql-general

From Tom Lane
Subject Re: Idle in transaction ????
Date
Msg-id 19654.1005864720@sss.pgh.pa.us
Whole thread Raw
In response to Re: Idle in transaction ????  (wsheldah@lexmark.com)
List pgsql-general
wsheldah@lexmark.com writes:
> If vacuum in 7.2 skips tables it can't lock,

It does not.

The real change in 7.2 is that vacuum requires only an ordinary writer's
lock on the table, not exclusive lock.  Since a write lock doesn't
conflict with read or write locks (basically it only conflicts with
schema-changing operations) we expect that vacuum will run concurrently
with most ordinary database operations.

            regards, tom lane

pgsql-general by date:

Previous
From: Glenn Sullivan
Date:
Subject: spectral datasets in postgresql
Next
From: Tom Lane
Date:
Subject: Re: Create Rule