Rudi Starcevic <rudi@oasis.net.au> 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