Re: vacuum and table locking

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: vacuum and table locking
Дата
Msg-id 93CAB446-41FF-4032-935D-CBABFF233906@elevated-dev.com
обсуждение исходный текст
Ответ на vacuum and table locking  (John Scalia <jayknowsunix@gmail.com>)
Ответы Re: vacuum and table locking  (Scott Whitney <scott@journyx.com>)
Список pgsql-admin
On Apr 3, 2015, at 9:59 AM, John Scalia <jayknowsunix@gmail.com> wrote:
>
> So the lock should only be during this move, or does it lock the table for the entirety?

The entirety. It doesn't know how to track changes that occur during the copying to the new table and apply them after,
soit locks it the whole time. (Just went through this myself...) 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







В списке pgsql-admin по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: vacuum and table locking
Следующее
От: Scott Whitney
Дата:
Сообщение: Re: vacuum and table locking