Re: Deadlock in vacuum (check fails) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Deadlock in vacuum (check fails)
Date
Msg-id 19782.1265037089@sss.pgh.pa.us
Whole thread Raw
In response to Re: Deadlock in vacuum (check fails)  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> Does this create a problem combined with the plan to allow the new
> VACUUM FULL to rewrite system tables? From my brief scan it sounds
> like the only reason there's no race condition here is that previously
> the oid of system tables couldn't change out from under
> load_critical_index.

Their OIDs will never change, so I don't see an issue.  Locks are taken
on OIDs not relfilenodes, so a relocation doesn't break locking.  If
it did we'd already have a problem with relocating user tables.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Hot Standby and VACUUM FULL
Next
From: Simon Riggs
Date:
Subject: Re: Hot Standby and VACUUM FULL