Re: Vaccuum allows read access?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Bruce Momjian <pgman@candle.pha.pa.us>

Cc: Alfred Perlstein <bright@wintelcom.net>, PostgreSQL HACKERS <pgsql-hackers@postgresql.org>

Date: 2000-07-21T19:15:27Z

Lists: pgsql-hackers

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> In the current sources, analyze allows read-access.  I don't think
> vacuum allows any other access because the rows are moving in the file.

VACUUM *must* have exclusive lock.

ANALYZE actually is only a reader (AccessShareLock) and does not lock
out either reading or writing in current sources.

			regards, tom lane