Re: VACUUM FULL vs backup/restore

Поиск
Список
Период
Сортировка
Искать
От
Vick Khera
Тема
Re: VACUUM FULL vs backup/restore
Дата
Msg-id
g2v2968dfd61004271450m1d84fe5bq7b48333821b330a3@mail.gmail.com
Ответ на
VACUUM FULL vs backup/restore (David Wall)
Список
Дерево обсуждения
VACUUM FULL vs backup/restore David Wall <d.wall@computer.org>
Re: VACUUM FULL vs backup/restore Greg Smith <greg@2ndquadrant.com>
Re: VACUUM FULL vs backup/restore Vick Khera <vivek@khera.org>
Re: VACUUM FULL vs backup/restore Scott Marlowe <scott.marlowe@gmail.com> 
On Tue, Apr 27, 2010 at 4:50 PM, David Wall  wrote:
> It seems my options are 1) VACUUM FULL with a reindex_db; or 2) backup, then
> restore.
>

I'd go with the backup+restore.  The other option is to to a trivial
ALTER to one of your fields which causes the table to be rewritten.

Basically, anything is faster than a VACUUM FULL in my experience.
В списке pgsql-general по дате отправления
Предыдущее
От: Chris Copeland
Дата:
Следующее
От: Scott Marlowe
Дата:
FAQ