Postgres Pro
Downloads
Home   >   mailing lists

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

From Francisco Reyes
Subject Re: Is vacuum full lock like old's vacuum's lock?
Date
Msg-id 20020301172120.N6753-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Is vacuum full lock like old's vacuum's lock?  (Doug McNaught <doug@wireboard.com>)
List pgsql-general
Tree view 
On 1 Mar 2002, Doug McNaught wrote:

> 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".

Thanks. So I will continue to do it "off hours".

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Shared buffers vs large files
Next
From: Tom Lane
Date:
Subject: Re: storing intermediate results in recursive plpgsql functions