Summary
In this chapter, we introduced the topic of table partitioning in PostgreSQL. Partitioning tables is useful as they become bigger and bigger, making queries slower and slower. We started by introducing the basic concepts of partitioning. We talked about range partitioning, list partitioning, and hash partitioning. We also went through some examples of list partitioning and range partitioning using tablespaces.
We will return to talking about partitioning in Chapter 13, Indexes and Performance Optimization. In the next chapter, we will talk about how PostgreSQL manages users, roles, and in general, the security of our database.
