MISSION 261

Vacuuming Postgres Databases

Learn about database vacuuming and how it decreases query speeds.

Objectives

  • Learn about database vacuuming
  • Learn about a transaction block
  • Learn what ACID means for database transactions

Mission Outline

1. Destructive Queries
2. ACID and Dead Rows
3. Counting Dead Rows
4. Vacuuming Dead Rows
5. Transaction Blocks
6. Updating Statistics
7. Full Vacuum
8. Autovacuum
9. Next Steps
10. Takeaways

postgres-for-data-engineers

Course Info:

Postgres for Data Engineers

Intermediate

The median completion time for this course is 5.2 hours.

This course requires a premium subscription. This course includes five missions, one installation tutorial and one guided project.  It is the first course in the Data Engineer path.

START LEARNING FREE

Take a Look Inside