Lists: | pgsql-announce |
---|
From: | Michael Glaesemann <michael(dot)glaesemann(at)myyearbook(dot)com> |
---|---|
To: | pgsql-announce(at)postgresql(dot)org |
Subject: | plproxyrc and partmanteau released |
Date: | 2010-10-19 20:27:30 |
Message-ID: | 458E9149-CE4E-4E86-8545-91688F192775@myyearbook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-announce |
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. It is most definitely not a complete solution, nor is it intended to be. But it does provide enough to make common tasks easier with 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 are written in PL/pgSQL and live within the database. No external scripts required!
Michael Glaesemann
michael(dot)glaesemann(at)myyearbook(dot)com