Finally tired of the poor performance and quality of service I've experienced with Apollo Hosting, I've pulled eject and moved the site to another provider, Westhost.
The only real hurdle was porting my PostgreSQL-based weblog code to MySQL. I really do
like PostgreSQL, but it's not widely offered, and it no longer seems to have any
remarkable benefit over MySQL, at least not for me. The InnoDB tables in MySQL support
foreign keys, integrity checks, and cascading deletes, and MySQL even supports subselects
now. I used InnoDB heavily at a previous job so it was kind of like putting on an old
pair of shoes.
So... as often is the case, this is a good thing in the end. While the new service isn't
quite as featureful (e.g. ssh, but no root access), it cost half as much, has all the
latest software (Apache, MySQL, PHP), and based on some impromptu benchmarks seems to be
33% - 50% faster. We'll see how things stand in six months though.