Re: Process Files - Mailing list pgsql-admin

From Tom Lane
Subject Re: Process Files
Date
Msg-id 19349.1068130129@sss.pgh.pa.us
Whole thread Raw
In response to Process Files  (Rudi Starcevic <rudi@oasis.net.au>)
Responses Re: Process Files
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Marek Florianczyk
Date:
Subject: Re: performance problem - 10.000 databases
Next
From: Christopher Browne
Date:
Subject: Re: Microsoft access verses postgresql