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
