Thread: plproxyrc and partmanteau released

plproxyrc and partmanteau released

From
Michael Glaesemann
Date:
myYearbook.com is pleased to announce the release of two libraries.

plproxyrc - PL/Proxy Remote Config
<http://github.com/myYearbook/plproxyrc>
High-level overview:
 * Function API for table-based PL/Proxy cluster configuration
 * Remote lookup of cluster configuration (via PL/Proxy)
 * Local caching of remote cluster configuration

partmanteau - PostgreSQL Partition Management Tool
<http://github.com/myYearbook/partmanteau>
partmanteau is a set of tables and functions to simplify creation and deletion of partitions in PostgreSQL databases.
Itis most definitely not a complete solution, nor is it intended to be. But it does provide enough to make common tasks
easierwith a lot of flexibility with respect to your partitioning strategies. 

myYearbook. has been using both plproxyrc and partmanteau strategies successfully in production for over 6 months. Both
arewritten in PL/pgSQL and live within the database. No external scripts required! 

Michael Glaesemann
michael.glaesemann@myyearbook.com