Blog

Your dream job? Lets Git IT.
Interactive technical interview preparation platform designed for modern developers.

XGitHub

Platform

  • Categories

Resources

  • Blog
  • About the app
  • FAQ
  • Feedback

Legal

  • Privacy Policy
  • Terms of Service

© 2025 LetsGit.IT. All rights reserved.

LetsGit.IT/Categories/PostgreSQL
PostgreSQLmedium

What is `VACUUM FULL` and why can it be disruptive?

Tags
#vacuum-full#bloat#locks
Back to categoryPractice quiz

Answer

`VACUUM FULL` rewrites the whole table to compact it and reclaim space. It takes stronger locks and can block reads/writes on that table, so it’s disruptive; prefer regular VACUUM/autovacuum and fix bloat causes first.

Related questions

PostgreSQL
Advisory locks: what are they and when would you use them?
#postgres#locks#advisory
PostgreSQL
VACUUM vs VACUUM FULL: what’s the difference?
#postgres#vacuum#maintenance
PostgreSQL
PostgreSQL bloat: what causes it and how do you reduce it?
#postgres#mvcc
#vacuum
PostgreSQL
Why do we need VACUUM (and autovacuum) in PostgreSQL?
#vacuum#autovacuum#bloat