Mike gave a great talk to the San Francisco PostgreSQL User Group in which he discussed their PostgreSQL setup.

Slides: http://media.postgresql.org/sfpug/instagram_sfpug.pdf

Video: http://www.ustream.tv/recorded/21929154