MISSION 258

Exploring Postgres Internals

Learn how Postgres stores internal data and how we can access it.

Objectives

  • Learn how Postgres manages meta information about databases and tables.
  • Learn what a Postgres schema is.
  • Learn how to create a description of a database from scratch.

Mission Outline

1. Introduction
2. Investigating the Tables
3. Working with Schemas
4. Describing the Tables
5. Type Code Mappings
6. Readable Description Types
7. Number of Rows
8. Sample Rows
9. Next Steps
10. Takeaways

optimizing-postgres-databases-data-engineering

Course Info:

Intermediate

The median completion time for this course is 4.7 hours. ​View Details​​​

This course is free and includes five missions. It is the second course in the Data Engineer path.

START LEARNING FREE

Take a Look Inside