The site was down for most of this morning because the database gobbled up all available memory and the VPS killed the process. I've decreased the memory limit for now. I've additionally set up monit to monitor the process to make sure it's never down for more than a minute now.
Updated by Youko