How to increase the max number of open files for Linux users

This forum post has a fine introduction into various file limits and a short tutorial on using /etc/security/limits.conf to set user limits.