Postgres Pro
Downloads
Home   >   mailing lists

Recommendation to run vacuum FULL in parallel - Mailing list pgsql-general

From Perumal Raj
Subject Recommendation to run vacuum FULL in parallel
Date
Msg-id CALvqh4q3SnBAh+eFCmGVgcH7KH0eCeA2ttf4wU3OUwEWPFggyg@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: New LLVM JIT Features
Next
From: Ron
Date:
Subject: Re: Recommendation to run vacuum FULL in parallel