"Jim C. Nasby" <jim(at)nasby(dot)net> writes:
> Is there any ALTER that would require blocking selects?
DROP INDEX, for certain.
> Even stuff like
> drop and rename should be protected by versioning, no?
No. System-catalog changes are always READ COMMITTED mode.
regards, tom lane