At home we canceled our cable subscription a few months ago. We hardly ever used it any more. Instead we were downloading content to a makeshift media server and watching it on our own schedule. Many of the shows I like (e.g., Colbert Report) aren't even available over here.
Upstairs we had a gorgeous big screen HDTV set that was being powered by one of my old computers, a nice P4 machine with 1GB of memory that was running the TurnKey Torrent Server appliance on bare metal.
Then it died. Traced it back to the motherboard being fried by a faulty power unit. Facing an immediate home entertainment emergency, I rummaged through the basement and found an old P3 machine with 256MB of old-style memory (I.e., the kind you can't get any more of these days).
I transferred the hard drive but of course GNOME choked so bad with 256MB that I decided to just turn X off. So we still had our home server but the screen went down on our big screen TV. A sad sight.
The first test is simply to check how much memory is used after a fresh boot of the respective live CDs, all the way into the default desktop.LXDE based Lubuntu: 57,908 KB
XFCE based Xubuntu: 156,852 KB
GNOME based Ubuntu: 153,840 KB
It wasn't available in 8.04 so I had never come across it before. I installed it on our ancient franken-server and I'm impressed.
The server not only works, it zips! It looks nice and modern, easy to configure, pretty much everything works out of the box (e.g., auto-generated application menus, virtual desktops, cpu monitor, date and clock).
Looks like an excellent candidate for the upcoming TurnKey Core Client. Unsurprisingly, Ubuntu are so impressed with it there's talk of a new Ubuntu derivative based on it called Lubuntu.