Sample Header Ad - 728x90

PostgreSQL difference between VACUUM FULL and CLUSTER

20 votes
2 answers
15497 views
I have a table with 200 GB of size occupied by data and 180 GB of size by the 6 indexes on it. It is 30% bloated, so I want to reclaim unwanted space occupied by it. It is clustered on job_id_idx index. So to reclaim the space do I need to use cluster command or vacuum full command? 1. What is the difference between this two command ? 2. Is vacuum full order by some column same as cluster command? 3. Is index recreated in both the commands? 4. In my case which one will be faster? The version of PostgreSQL database is 9.1
Asked by Arun P (201 rep)
Jul 22, 2013, 01:07 PM
Last activity: May 2, 2023, 02:09 PM