Configure and manage Azure Database for PostgreSQL
Azure Database for PostgreSQL employs system catalogs and views to manage metadata efficiently. Understanding these can significantly enhance database performance and streamline the administration of PostgreSQL systems.
Learning objectives
After completing this module, you'll be able to:
Describe system catalogs and system views in Azure Database for PostgreSQL.
Investigate metadata in Azure Database for PostgreSQL.
Explain the purpose of the vacuum process.
Configure vacuum server parameters.
Prerequisites
Demonstrate an understanding of relational databases.
Demonstrate an understanding of basic SQL.