Learn PostgreSQL - Second Edition

9

Partitioning

In the previous chapter, we talked about rules and triggers. In this chapter, we will talk about partitioning. Partitioning is a technique that allows us to split a huge table into smaller tables to make queries more efficient. In this chapter, we will see how we can partition data, and, in some cases, how we can use the rules and triggers seen in the previous chapter to make partitioning possible. We will start by introducing the basic concepts of partitioning, and then we will see the possibilities PostgreSQL offers to implement partitioning.

This chapter will cover the following topics:

• Basic concepts
• Partitioning using table inheritance
• Declarative partitioning

Technical requirements

The chapter examples can be run on the ...