RE: safety of vacuum verbose analyze on active tables

Поиск
Список
Период
Сортировка
От Andrew Snow
Тема RE: safety of vacuum verbose analyze on active tables
Дата
Msg-id NHEALMDKDACEIPBNOOOCEEGBCCAA.als@fl.net.au
обсуждение исходный текст
Ответ на safety of vacuum verbose analyze on active tables  (Jim Mercer <jim@reptiles.org>)
Ответы Re: safety of vacuum verbose analyze on active tables  (Jim Mercer <jim@reptiles.org>)
Список pgsql-general
> what is the relative safety of doing a vacuum verbose analyze on a 24Gb
> table while there are selects and updates/inserts happening on it?

As far as I know, the table is locked completely during a Vacuum. Any
transactions attempting to do inserts/updates will be paused safely. So go
ahead and schedule your vacuums for whenever you need to.


- Andrew



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

Предыдущее
От: Jim Mercer
Дата:
Сообщение: safety of vacuum verbose analyze on active tables
Следующее
От: Haroldo Stenger
Дата:
Сообщение: Re: excell to postgres