Re: Is vacuum full lock like old's vacuum's lock?

From: Doug McNaught <doug(at)wireboard(dot)com>
To: Francisco Reyes <lists(at)natserv(dot)com>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is vacuum full lock like old's vacuum's lock?
Date: 2002-03-01 21:51:53
Message-ID: m3it8gq7ly.fsf@varsoon.denali.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Francisco Reyes <lists(at)natserv(dot)com> writes:

> Recently moved to 7.2 and have been mainly doing "vacuum analyze". I have
> only run "vacuum full" on the weekend when nobody is using the server. I
> am wondering if "vacuum full" locks the tables like the old vacuum did.

AFIAK "vacuum full" is exactly the same as the old "vacuum".

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fran Fabrizio 2002-03-01 21:55:43 storing intermediate results in recursive plpgsql functions
Previous Message Francisco Reyes 2002-03-01 21:50:13 Is vacuum full lock like old's vacuum's lock?