tgreSQL</SPAN
> server. Of particular
    importance are limits on the number of processes per user, the
    number of open files per process, and the amount of memory available
    to each process. Each of these have a <SPAN
CLASS="QUOTE"
>"hard"</SPAN
> and a
    <SPAN
CLASS="QUOTE"
>"soft"</SPAN
> limit. The soft limit is what actually counts
    but it can be changed by the user up to the hard limit. The hard
    limit can only be changed by the root user. The system call
    <CODE
CLASS="FUNCTION"
>set