Recommendation to run vacuum FULL in parallel

Поиск
Список
Период
Сортировка
От Perumal Raj
Тема Recommendation to run vacuum FULL in parallel
Дата
Msg-id CALvqh4q3SnBAh+eFCmGVgcH7KH0eCeA2ttf4wU3OUwEWPFggyg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Recommendation to run vacuum FULL in parallel
Re: Recommendation to run vacuum FULL in parallel
Список pgsql-general
Hi ALL

We are  planning to reclaim unused space from 9.2 Version postgres Cluster,

Method : VACUUM FULL
DB Size : 500 GB
Expected space to reclaim 150 GB
work_mem : 250 MB
maintenance_work_mem : 20 GB

Question :

1. vacuumdb --j option (Parallel) not available for version 9.2.
  How to run vacuum full in parallel ? At present its taking 8Hrs if i run sequential ( vacuum full verbose;)

2. If we run vacuum full, Do we need to run REINDEX/ANALYZE exclusively ?

3. What is the best way to run VACUUM FULL with less window.

Thanks,
Raj

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