700 XP

Optimize vacuum in Azure Database for PostgreSQL

  • 24 min
  • Module
  • 6 Units
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.
Start

Prerequisites

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

Module assessment

Assess your understanding of this module. Sign in and answer all questions correctly to earn a pass designation on your profile.

Take the module assessment