Typically, disk access is a bottleneck. With a huge database, you'll want as much RAM as possible, too (assuming that your OS and DB server software will do some caching...).
So, fast disks and plenty of RAM.
This, of course, from a guy who builds servers from the junk in his closet.
Good luck!