VACUUM FULL

Поиск
Список
Период
Сортировка
От Marcin Krol
Тема VACUUM FULL
Дата
Msg-id 4911A403.6040302@gmail.com
обсуждение исходный текст
Ответы Re: VACUUM FULL  ("Serge Fonville" <serge.fonville@gmail.com>)
Список pgsql-novice
Hello everyone,

I've done VACUUM FULL on my db and noticed that it reclaimed
considerably more diskspace than regular VACUUM.

Should I use VACUUM FULL or not? Are there any downsides/risks to it
(other than that it locks the table while vacuuming)?

Conversely, are there any performance advantages of db after doing
VACUUM FULL?

The docs on VACUUM FULL do not say what it does exactly (in detail)..


Regards,
Marcin Krol

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

Предыдущее
От: Marcin Krol
Дата:
Сообщение: calculating table sizes + total in one query
Следующее
От: "Serge Fonville"
Дата:
Сообщение: Re: VACUUM FULL