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

Course Info:

Optimizing Postgres Databases

Intermediate

The average completion time for this course is 10-hours.

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

START LEARNING FREE

Take a Look Inside

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit