Re: Process Files

Rudi Starcevic <rudi(at)oasis(dot)net(dot)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