This engineering blog by Instagram co-founder Mike Krieger is another great example of the robust feature set available today in PostgreSQL to handle some of the most modern of database scalability problems. Note that he highlights not just core features, but tools from the Postgres ecosystem like pg_reorg and Wal-E as well as some nice tweaks done with one of the many supported server-side languages (in this case Python's psycopg2). Check out this short and informative read here (http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from-instagram).
