Thread: How does vacuum works in postgresql

How does vacuum works in postgresql

From
Rama Krishnan
Date:
Hi Experts, 

I read this tutorials blog on edb it says vacuum has three phases 
1.ingest phase
2.pruning phase
3.cleaning phase

Apart from this blog, no one has explained about the vacuum working 


I m getting confusion on each can anyone explain me 



Thanks& Regards
RK


Re: How does vacuum works in postgresql

From
Michael Lewis
Date:
Your question is a bit vague, and your referenced article is quite old. It doesn't reference pg_stat_progress_vacuum* even despite 9.6 being out for a while before the article. What version are you using and what questions or problems do you have that you think are related to vacuum?

*See below