Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL Partition Manager v1.5.1 - Constraint Management - Mailing list pgsql-announce

From Keith Fiske
Subject PostgreSQL Partition Manager v1.5.1 - Constraint Management
Date
Msg-id CAG1_KcDvEgj_4KDP1iBr=AEaFS=kmLT_HWz9_96-0JgjcmpZog@mail.gmail.com
Whole thread Raw
List pgsql-announce
Tree view
Version 1.5.1 of the PostgreSQL Partition Manager extension (pg_partman) was released with a new constraint management feature. It allows the constraint exclusion feature of PostgreSQL to be applied on columns other than the column used to control the partitioning scheme. When applicable, it can greatly increase the performance of queries against very large partitions sets.

A blog post detailing the feature can be found here - http://www.keithf4.com/managing-constraint-exclusion-in-table-partitioning/

The extension is maintained on github and can be downloaded there or from pgxn.

https://github.com/keithf4/pg_partman
http://pgxn.org/dist/pg_partman/

--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com

pgsql-announce by date:

Previous
From: David Fetter
Date:
Subject: == PostgreSQL Weekly News - January 12 2014 ==
Next
From: David Fetter
Date:
Subject: == PostgreSQL Weekly News - January 19 2014 ==