My blog is a Django app running on a 512MB Rackspace VM with a basic Apache, mod_wsgi, and Postgres setup. I have a dozen low traffic applications all running on the same server alongside it. I have zero caching set up so every hit is doing the full process of querying the database and pushing the results out through a template.
I was on the front page of HN last year and the server load was negligable. I have graphs: http://thraxil.org/users/anders/posts/2012/06/02/How-Django-...