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 average completion time for this course is 10-hours.

This course requires a premium subscription. This course includes 1 free mission, 4 paid missions, 1 installation tutorial and 1 guided project.  It is the 1st course in the Data Engineer path.

START LEARNING FREE

Take a Look Inside