Partitioning
Explore the concept of table partitioning in PostgreSQL, including its types and limitations. Understand how partitioning differs from denormalization and the constraints involved, such as lack of global primary keys and foreign key support across partitions. Gain insight into practical considerations before applying partitioning to optimize database performance.
We'll cover the following...
We'll cover the following...
Partitioning refers to splitting a table with too many rows into a set of tables, each containing a part of those rows. Several kinds of partitioning are available, such as list or range partitioning. Starting in PostgreSQL 10, table partitioning is supported directly.
Partitioning is not denormalization
While partitioning isn’t denormalization, the limits of ...