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  ("Andrew Snow" <als@fl.net.au>)
Re: [HACKERS] safety of vacuum verbose analyze on active tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

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