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

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Is vacuum full lock like old's vacuum's lock?
Дата
Msg-id 20020301172120.N6753-100000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Re: Is vacuum full lock like old's vacuum's lock?  (Doug McNaught <doug@wireboard.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: Shared buffers vs large files
Следующее
От: Tom Lane
Дата:
Сообщение: Re: storing intermediate results in recursive plpgsql functions