Search Documentation: Home → Documentation → Manuals → PostgreSQL 9.6 This page in other versions: 9.2 / 9.3 / 9.4 / 9.5 / current (9.6) |  Development versions: devel / 10 |  Unsupported versions: 8.1 / 8.2 / 8.3 / 8.4 / 9.0 / 9.1 PostgreSQL 9.6.4 Documentation Prev Up Chapter 5. Data Definition Next 5.10. Partitioning PostgreSQL supports basic table partitioning. This section describes why and how to implement partitioning as part of your database design. 5.10.1. Overview Partitioning refers to splitting what is logically one large table into smaller physical pieces. Partitioning can provide several benefits: Query performance can be improved dramatically in certain situations, particularly when most of the heavily accessed rows of the table are in a single partition or a small number of partition...