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

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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Is vacuum full lock like old's vacuum's lock?
Следующее
От: Fran Fabrizio
Дата:
Сообщение: storing intermediate results in recursive plpgsql functions