safety of vacuum verbose analyze on active tables

Поиск
Список
Период
Сортировка
От Jim Mercer
Тема safety of vacuum verbose analyze on active tables
Дата
Msg-id 20000417102202.F26070@reptiles.org
обсуждение
Ответы RE: safety of vacuum verbose analyze on active tables
Re: [HACKERS] safety of vacuum verbose analyze on active tables
Список pgsql-general
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 по дате отправления: