"Jackson, DeJuan" wrote:
>
> What about potential deadlocking issues with vacuum? Haven't tried to
> deadlock vacuum, but wondering if it's possible.
Shouldn't be possible.
Vacuum never acquires AccessExclusive lock on more than
one table at once. This lock is released immediately
after a relation processed.
SELECT/COPY_TO queries from pg_dump lock relations
in AccessShare mode for duration of query.
Vadim