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_id
x 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
Last activity: May 2, 2023, 02:09 PM