Dump/Restore vs Vacuum Full

Поиск
Список
Период
Сортировка
От Adi Alurkar
Тема Dump/Restore vs Vacuum Full
Дата
Msg-id 682E2026-FC7B-11D8-9429-000A95C4BD7A@sf.net
обсуждение исходный текст
Ответы Re: Dump/Restore vs Vacuum Full  (Adi Alurkar <adi@sf.net>)
Список pgsql-admin
Greetings,

Are there any differences, advantages of running a dump/restore vs
running the following:1)REINDEX all the tables in all the databases,
2)VACUUM FULL ANALYZE on all the databases

Assuming the following
1) the system can be offline.
2) PG version 7.4.x
3) pg_autovacuum running as a daemon with 30 minutes sleep but have had
a few occasions where pg_autovacuum had to be killed and restarted.
4) FSM settings are set > than required by VACUUM ANALYZE VERBOSE
"test".

-Adi


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

Предыдущее
От: "Richard Harris"
Дата:
Сообщение: Information about psqlODBC parameters
Следующее
От: tim hall
Дата:
Сообщение: Re: Create Linux Script for PostgreSQL database backup