I ran the same generator task on Gradwell and the Linode. On Linode, it took 21m1.1s, on Gradwell, 1m0.5s. Kind of a huge difference, don’t you think? So I copied the database and code to my home machine, which has 1024Mb of RAM instead of 96Mb, and dual Athlon MP1800+ processors, and it still takes 7m46s.
So either Postgres is way slower than MySQL, or I’ve done something really wrong when I ported the code.
I guess my next move is to try the Gradwell MySQL code on my home server and see how long it takes.