Recommendation to run vacuum FULL in parallel

Поиск

Список

Период

Сортировка

От	Perumal Raj
Тема	Recommendation to run vacuum FULL in parallel
Дата	3 апреля 2019 г. 08:50:47
Msg-id	CALvqh4q3SnBAh+eFCmGVgcH7KH0eCeA2ttf4wU3OUwEWPFggyg@mail.gmail.com обсуждение исходный текст
Ответы	Re: Recommendation to run vacuum FULL in parallel (Ron <ronljohnsonjr@gmail.com>) Re: Recommendation to run vacuum FULL in parallel (Laurenz Albe <laurenz.albe@cybertec.at>)
Список	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 по дате отправления:

От: Andres Freund
Дата: 03 апреля 2019 г., 08:23:44
Сообщение: Re: New LLVM JIT Features

От: Ron
Дата: 03 апреля 2019 г., 09:22:02
Сообщение: Re: Recommendation to run vacuum FULL in parallel