Pg_shard – PostgreSQL extension to scale out real-time reads and writes
At work we're in the midst of rolling out a sharded Postgres platform based on <a href="http://www.craigkerstiens.com/2012/11/30/sharding-your-database/" rel="nofollow">http://www.craigkerstiens.com/2012/11/30/sharding-your-datab...</a>, with the sharding implemented at the application level.  The biggest piece of complexity in that post is around designing the sharding in such a way that you can gracefully add more shards later.<p>Having read the pg_shard readme, it's not clear to me how it addresses that issue.  I'd need to have a really clear idea how to handle scaling my cluster before committing to a sharding solution.