How does vacuum works in postgresql
Started by Rama Krishnanover 5 years ago2 messagesgeneral
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
https://www.enterprisedb.com/postgres-tutorials/how-does-vacuum-work-postgresql
Thanks& Regards
RK
Re: How does vacuum works in postgresql
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
https://www.postgresql.org/docs/current/progress-reporting.html#VACUUM-PROGRESS-REPORTING