Postgres Pro
Downloads
Home   >   mailing lists

Re: Proposal - Reduce lock during first phase of VACUUM TRUNCATE from ACCESS EXCLUSIVE to EXCLUSIVE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal - Reduce lock during first phase of VACUUM TRUNCATE from ACCESS EXCLUSIVE to EXCLUSIVE
Date
Msg-id 1168693.1739854219@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal - Reduce lock during first phase of VACUUM TRUNCATE from ACCESS EXCLUSIVE to EXCLUSIVE  (Ramanathan <sivakrishnathan@gmail.com>)
List pgsql-hackers
Tree view 
Ramanathan <sivakrishnathan@gmail.com> writes:
> I propose modifying the use of an EXCLUSIVE lock during the backward scan
> phase, then upgrading that lock to ACCESS EXCLUSIVE only for the actual
> truncation phase. Since the truncation phase should be relatively quick,
> the impact of the ACCESS EXCLUSIVE lock should be minimal.

Except that mid-transaction lock upgrades increase the risk of
deadlock failures.

            regards, tom lane

pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.
Next
From: Amul Sul
Date:
Subject: Re: NOT ENFORCED constraint feature