Dump_partition.py
dump_partition.py
PostgreSQL Partition Manager
Install dump_partition.py
-
Debian
apt-get install postgresql-11-partmanClick to copy -
Ubuntu
apt-get install postgresql-11-partmanClick to copy -
Kali Linux
apt-get install postgresql-11-partmanClick to copy -
Raspbian
apt-get install postgresql-9.6-partmanClick to copy
postgresql-11-partman
PostgreSQL Partition Managerpg_partman is a PostgreSQL extension to create and manage both time-based and serial-based table partition sets. Sub-partitioning is also supported. Child table & trigger function creation is all managed by the extension itself. Tables with existing data can also have their data partitioned in easily managed smaller batches. Optional retention policy can automatically drop partitions no longer needed. A background worker (BGW) process is included to automatically run partition maintenance without the need of an external scheduler (cron, etc) in most cases.
postgresql-9.6-partman
PostgreSQL Partition Managerpg_partman is a PostgreSQL extension to create and manage both time-based and serial-based table partition sets. Sub-partitioning is also supported. Child table & trigger function creation is all managed by the extension itself. Tables with existing data can also have their data partitioned in easily managed smaller batches. Optional retention policy can automatically drop partitions no longer needed. A background worker (BGW) process is included to automatically run partition maintenance without the need of an external scheduler (cron, etc) in most cases.