Stopping vacuum

Поиск
Список
Период
Сортировка
От Werner Bohl
Тема Stopping vacuum
Дата
Msg-id 1088528969.30410.2.camel@sirio
обсуждение исходный текст
Ответы Re: Stopping vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi,

We have a very big db that was not vacuumed for a long time. We started
vacuum 3 days ago and it has not finished yet. There are some urgent
processes that have to be run against the db.

Is it safe to kill vacuum? It was started with 'vacuum full analyze'
Is there anyway to speed it up at next start?


TIA,

--
Werner Bohl <wbohl@deepdata.com>
Infutor de Costa Rica


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

Предыдущее
От: Ivo Rossacher
Дата:
Сообщение: Re: Change the character encoding of a database
Следующее
От: juanmime@ono.com
Дата:
Сообщение: Asunto: Re: pg_restore usage