Horton
Menu

Re: [HACKERS] 6.6 items

Vadim Mikheev <vadim@krs.ru>

View thread
From: Vadim Mikheev <vadim@krs.ru>
To: "Jackson, DeJuan" <djackson@cpsgroup.com>
Cc: Bruce Momjian <maillist@candle.pha.pa.us>, Thomas Lockhart <lockhart@alumni.caltech.edu>, Don Baccus <dhogaza@pacifier.com>, ZEUGSWETTER Andreas IZ5 <Andreas.Zeugswetter@telecom.at>, pgsql-hackers@postgreSQL.org, "'kar@webline.dk'" <kar@webline.dk>
Date: 1999-06-08T17:52:06Z
Lists: pgsql-hackers 
"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