Postgres Pro
Downloads
Home   >   mailing lists

Re: Is vacuum full lock like old's vacuum's lock? - Mailing list pgsql-general

From Doug McNaught
Subject Re: Is vacuum full lock like old's vacuum's lock?
Date
Msg-id m3it8gq7ly.fsf@varsoon.denali.to
Whole thread Raw
In response to Is vacuum full lock like old's vacuum's lock?  (Francisco Reyes <lists@natserv.com>)
Responses Re: Is vacuum full lock like old's vacuum's lock?  (Francisco Reyes <lists@natserv.com>)
List pgsql-general
Tree view 
Francisco Reyes <lists@natserv.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

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Is vacuum full lock like old's vacuum's lock?
Next
From: Fran Fabrizio
Date:
Subject: storing intermediate results in recursive plpgsql functions