Re: VACUUM FULL on 24/7 server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM FULL on 24/7 server
Дата
Msg-id 26607.1096758925@sss.pgh.pa.us
обсуждение исходный текст
Ответ на VACUUM FULL on 24/7 server  (Aleksey Serba <aserba@gmail.com>)
Список pgsql-general
Aleksey Serba <aserba@gmail.com> writes:
>    I have 24/7 production server under high load.
>    I need to perform vacuum full on several tables to recover disk
>    space / memory  usage frequently ( the server must be online during
> vacuum time )

Don't use VACUUM FULL; plain VACUUM should be enough if you are managing
the database properly (for instance, make sure the FSM settings are high
enough).

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: earthdistance is not giving correct results.
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: earthdistance is not giving correct results.