Basically I have 4GB of RAM (on the latest MBP) and regularly run: Netbeans IDE, Safari (and a bunch of tabs), Firefox (ditto on the tabs), an FTP client, a Subversion client, iChat, Mail, a notes app, alarm clock, Dropbox, Evernote, terminal, one other text editor (MacVim or Textwrangler), Photoshop, MS Word, a clipboard app and sometimes VirtualBox running Windows XP (with 1GB of RAM assigned).
The killers seem to be Netbeans and VirtualBox. Once I have those both going I know I'm in for a reboot before too long.
I assume it's just a RAM issue but it is annoying that 4GB isn't "enough" (assuming I'm correct about why I have to reboot).
Did you check top? free? You should be able to see what's eating your machine after a few days of uptime.
Does shutting down all the applications and re-opening them help? Something's got to be eating all of your RAM, and it's hard to guess without seeing top/Activity Monitor.
Word. For me, every Mac has been instant-on for years. I open the lid or hit the power button (iMac), and the machine is up and running (from sleep) in a second or two.
Using an Air as your main development machine seems odd to me - I want a large display so that I can read docs/papers and have emacs open at the same time. I also want good separation between screen and keyboard for maintaining decent posture. I hate to use a laptop as my main machine for exactly that reason. My main development machine doesn't get picked up and moved around enough (at all?) to be worth using a high end laptop. For the same price as the machine at the top of the page you could buy a decent desktop and a 13" Macbook and lunch, I guess.