We just experienced our first major availability issue, and were down for 20 minutes. Three database queries hung and would not respond to pg_cancel_backend or pg_terminate_backend. I'm working with Heroku support on figuring out how it happened and what we'll have to do to stop it from happening again.
trevor:
Earning that paycheck today! :D