Skip site navigation (1) Skip section navigation (2)

plproxyrc and partmanteau released

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce is pleased to announce the release of two libraries.

plproxyrc - PL/Proxy Remote Config
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
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

pgsql-announce by date

Next:From: JY WangDate: 2010-10-20 02:01:57
Subject: Re: [ANNOUNCE] PGDay Europe 2010 Registration Open
Previous:From: Mason SharpDate: 2010-10-19 16:04:56
Subject: NYC PostgreSQL Meetup Wednesday, Oct 20th

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group