Horton

Re: Vaccuum allows read access?

Marc G. Fournier <scrappy@hub.org>

View thread
From: The Hermit Hacker <scrappy@hub.org>
To: Alfred Perlstein <bright@wintelcom.net>
Cc: PostgreSQL HACKERS <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2000-07-21T18:56:33Z
Lists: pgsql-hackers 
On Fri, 21 Jul 2000, Alfred Perlstein wrote:

> 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?

the last change that I recall was by Bruce ... he got it so that it only
lock'd one table at a time and only held that lock for as long as was
required instead of for the duration of the vacuum ...