Migrating partitioned tables to PostgreSQL 10’s Native Partitioning

In this article, we will focus on upgrade from 9.4 (and above) versions to PostgreSQL 10, leveraging the full features of native partitioning. Test Environment: OS: CentOS 7 PostgreSQL version: 9.6.3 and 10.0 pg_partman version: 3.1.0 Migrating from 9.x version (partitioned table with inheritance) to pg10 (native partitioning) Consider a database with several tables some [...]