Why does VACUUM FULL bother locking pages? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Why does VACUUM FULL bother locking pages?
Date
Msg-id 20050916163925.GB6819@surnet.cl
Whole thread Raw
Responses Re: Why does VACUUM FULL bother locking pages?
Re: Why does VACUUM FULL bother locking pages?
Re: Why does VACUUM FULL bother locking pages?
List pgsql-hackers
Hackers,

I'm reading the vacuum code and I just noticed that the routines
move_plain_tuple and move_chain_tuple expect the dest and source blocks
to be locked, and unlock them at exit.  The only caller of both is
repair_frag, whose only caller in turn is full_vacuum_rel.  Same thing
for update_hint_bits.

So, the only callers of both has already acquired appropiate locks at
the relation level -- nobody is going to be modifying the blocks while
they proceed.  So why bother locking the pages at all?  Is there a
reason or is this an historical accident?

-- 
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"Puedes vivir solo una vez, pero si lo haces bien, una vez es suficiente"


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: US Census database (Tiger 2004FE) - 4.4G
Next
From: Josh Berkus
Date:
Subject: Re: Spinlocks, yet again: analysis and proposed patches