Understanding how and what a database is doing will help you make better choices when modeling the schema and performing queries.
In this chapter, we’ll use PostgreSQL as our primary example. While relational databases differ somewhat on their specific details, they more or less perform the same job in the same way. Thus, learning about PG will give you the knowledge necessary to ask the right questions for your database of choice.