From: | Keith Fiske <keith(at)omniti(dot)com> |
---|---|
To: | pgsql-announce(at)postgresql(dot)org |
Subject: | PostgreSQL Partition Manager v1.5.1 - Constraint Management |
Date: | 2014-01-15 00:56:18 |
Message-ID: | CAG1_KcDvEgj_4KDP1iBr=AEaFS=kmLT_HWz9_96-0JgjcmpZog@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2014-01-20 07:03:04 | == PostgreSQL Weekly News - January 19 2014 == |
Previous Message | David Fetter | 2014-01-13 04:25:39 | == PostgreSQL Weekly News - January 12 2014 == |