http://instagram-engineering.tumblr.com/post/10853187575/sha...
http://postgres-xc.sourceforge.net/
http://www.pgpool.net/mediawiki/index.php/Main_Page (you can use this to transparently shard)
http://instagram-engineering.tumblr.com/post/10853187575/sha...
http://postgres-xc.sourceforge.net/
http://www.pgpool.net/mediawiki/index.php/Main_Page (you can use this to transparently shard)
Instagram had to roll their own and Postgres XC, PGPool both have always seemed pretty sketchy. No official support, no notable customers, shocking complexity and everything just seems all over the place with documentation from say 2009 referencing PostgreSQL 8 e.g. PgPool beginner guide. They may be great solutions but do they really look like something that inspires confidence ?
These guys seem to have the right idea: http://www.cloudpostgres.com
It would just be nice to have something as simple and polished built into PostgreSQL.