In this chapter, we introduced the topic of table partitioning in PostgreSQL. Partitioning tables is useful when we have tables that 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 went through some examples of list partitioning and range partitioning. We also saw the two ways in which PostgreSQL solves the problem of partitioning tables: partitioning using inheritance and declarative partitioning.
In the following part of this book, 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.
