safety of vacuum verbose analyze on active tables

Поиск
Список
Период
Сортировка
i have always been cautious, and have tried to vacuum my tables when there
was little or no activity.

i now have a situation where that may not be possible any more.

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?

would it be safer to disable the update/insert processes?

--
[ Jim Mercer                 jim@reptiles.org              +1 416 506-0654 ]
[          Reptilian Research -- Longer Life through Colder Blood          ]
[  Don't be fooled by cheap Finnish imitations; BSD is the One True Code.  ]

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

Предыдущее
От: "Martin A. Marques"
Дата:
Сообщение: excell to postgres
Следующее
От: "Andrew Snow"
Дата:
Сообщение: RE: safety of vacuum verbose analyze on active tables