Pathman - the effective way to table partitioning in PostgreSQL


Dmitry Ivanov

Postgres Professional

Senior Developer

Table Partitioning is a highly demanded functionality of PostgreSQL. The existing possibility to make partitioning through inheritance has several serious disadvantages, such as ineffective planning, missing runtime optimization, need to manage triggers and sections manually.

This talk describes the pg_pathman extension developed by our team. pg_pathman supports HASH and RANGE partitioning and performs query optimization during planning and execution stages, allows fast includes by using custom executor nodes instead of triggers, supports FDW, lock-free data migration and other possibilities.

In conclusion I will describe the new features, expected in next releases, and our plans for integration with PostgreSQL 10.