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
