Horton

Re: Vaccuum allows read access?

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

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Alfred Perlstein <bright@wintelcom.net>
Cc: PostgreSQL HACKERS <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2000-07-21T18:58:01Z
Lists: pgsql-hackers 
> I could have sworn I saw a post where you (Tom Lane) figured out how
> to get tables to be read-only while performing a vaccuum rather than
> being completely locked.
> 
> Is this true?  Is it in the -PATCHES branch?

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.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026