pg_shard

(Disclaimer: I'm one of the authors of pg_shard.) pg_shard extends PostgreSQL without forking it, and it's worth a look: https://github.com/citusdata/pg_shard pg_shard v2.0 will target linear scaling and higher HA through metadata replication. If you have any questions or feedback for the project, we'd be happy to hear from you. If you're on AWS, you can already get linear scale and full HA. This post shows a proof-of-concept: https://goo.gl/3c2GYc

Depending on your exact requirements, you can use pg_shard [1] for real-time inserts/update/delete, or CitusDB [2] for scaling out selects, or combine them. [1] https://github.com/citusdata/pg_shard [2] http://www.citusdata.com/ Disclaimer: I work for Citus Data.