Rudi Starcevic <[EMAIL PROTECTED]> writes: > ERROR: _mdfd_getrelnfd: cannot open relation virtualusertable: Cannot > allocate memory
Hm, that's a rather odd error code, but I suppose it must mean that you have run out of kernel memory for file descriptor slots or inodes. > I'd like to try limiting the amount of files per process. > Is there an option I can configure to do this ?? max_files_per_process. If you don't have it you need a newer version of Postgres. Note that you could also attack this by increasing the kernel filetable size; I forget exactly how to do that in Linux, but it is possible. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster