Re: Upgrading Queries
Check out the plan comparison page. Yes, you get 128MB of memory, along with increased execution time and 1-minute cron intervals. As you can see from the comparison chart, there's not much in the way of resources that can be doubled -- it's all-you-can-eat databases and email addresses, etc. (I'm sure there are "reasonable limits" involved -- if you were to start storing terabytes, the bartender will likely cut you off and call a cab.)
That said, the unmanaged S1 VPS paid annually is pretty darned cheap at $6.71/mo if the Premium plan doesn't fill your needs. If you need a managed server (let's say for argument's sake that you either hate sysadmin or don't know enough about it to keep a secure server) but don't need to install anything beyond the LAMP defaults (or I guess that's LLMP around here now), the Infinity+ plan would be a lot cheaper than a managed VPS if Premium is undersized/underpowered. I'm not suggesting you spend money you don't have to spend, just pointing out all of the options.
“Beware of bugs in the above code; I have only proved it correct, not tried it.” --Donald Knuth
"It was as if its architects were given a perfectly good hammer and gleefully replied, 'neat! With this hammer, we can build a tool that can pound in nails.'" -- Alex Papadimoulis (on TheDailyWTF.com)