Optimize vacuum in Azure Database for PostgreSQL

Intermediate
Database Administrator
Azure Database for PostgreSQL

Azure Database for PostgreSQL uses vacuum and autovacuum to remove rows that have been marked as soft-deleted after an update or deletion.

Learning objectives

After completing this module, you'll be able to:

  • Explain the purpose of vacuum and autovacuum.
  • Configure autovacuum server parameters.

Prerequisites

  • Demonstrate an understanding of relational databases.
  • Demonstrate an understanding of basic SQL.