Skip site navigation (1) Skip section navigation (2)

Re: Vaccuum allows read access?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Alfred Perlstein <bright(at)wintelcom(dot)net>
Cc: PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Vaccuum allows read access?
Date: 2000-07-21 18:56:33
Message-ID: Pine.BSF.4.21.0007211555510.325-100000@thelab.hub.org (view raw or flat)
Thread:
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 ...



In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-07-21 18:58:01
Subject: Re: Vaccuum allows read access?
Previous:From: Alfred PerlsteinDate: 2000-07-21 18:52:37
Subject: Vaccuum allows read access?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group