Tuesday, January 01, 2013

Announcing pg_part extension, a table partitioning utility for PostgreSQL

I'm pleased to announce my first PostgreSQL extension, pg_part extension, to take advantage of table (range) partitioning on PostgreSQL. In the PostgreSQL world, the table (range) partitioning (a.k.a. Constraint Exclusion) is one of the advantages of PostgreSQL for analytical workloads, but using lots of DDL commands for this purpose still requires some patience. This extension provies several SQL functions to allow users manipulating table partitioning on PostgreSQL without executing DDL commands directly. So, pg_part would make it easier to take advantages of the PostgreSQL table partitioning.