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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-07-21 18:58:01 Re: Vaccuum allows read access?
Previous Message Alfred Perlstein 2000-07-21 18:52:37 Vaccuum allows read access?