Postgres Pro
Downloads
Home   >   mailing lists

Re: Vaccuum allows read access? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Vaccuum allows read access?
Date
Msg-id 23703.964206927@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vaccuum allows read access?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Vaccuum allows read access?  (JanWieck@t-online.de (Jan Wieck))
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: About these IPC parameters
Next
From: Thomas Lockhart
Date:
Subject: Re: Geometry test broken