Summary

  • 1 minute

You work as a database engineer supporting cloud-based databases in Azure. You should now understand how to view system information to gain deeper insight into how to administer Azure Database for PostgreSQL databases. You learned how to find information about vacuum and autovacuum configuration. How to identify where you can reclaim lost space by removing rows marked for deletion. You also learned about the other benefits of running vacuum, and how to configure the relevant server parameters.

Now that you completed this module, you should 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.

Resources

Use these resources to discover more information about the topics covered in this module: