blob: 2984e5f7e6a0012e1749e3af7a4aed86dff91fdd (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
pg_partman is an extension to create and manage both time-based and number-based
table partition sets. As of version 5.0.1, only built-in, declarative
partitioning is supported and the older trigger-based methods have been
deprecated.
The declarative partitioning built into PostgreSQL provides the commands to
create a partitioned table and its children. pg_partman uses the built-in
declarative features that PostgreSQL provides and builds upon those with
additional features and enhancements to make managing partitions easier. One key
way that pg_partman extends partitioning in Postgres is by providing a means to
automate the child table maintenance over time (Ex. adding new children,
dropping old ones based on a retention policy). pg_partman also has features to
turn an existing table into a partitioned table or vice versa.
A background worker (BGW) process is included to automatically run partition
maintenance without the need of an external scheduler (cron, etc) in most cases.
|
