Re: Idle in transaction ????

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: wsheldah(at)lexmark(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Idle in transaction ????
Date: 2001-11-15 22:52:00
Message-ID: 19654.1005864720@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

wsheldah(at)lexmark(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-15 22:54:26 Re: Create Rule
Previous Message Tom Lane 2001-11-15 22:49:44 Re: Bug?