Process Files - Mailing list pgsql-admin

From Rudi Starcevic
Subject Process Files
Date
Msg-id 3FA9E266.7090800@oasis.net.au
Whole thread Raw
Responses Re: Process Files  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,

I'm moving a Postgresql database onto a co-located server - a Linux
Virtual Server.

Today I got some error's in my logs:

ERROR:  _mdfd_getrelnfd: cannot open relation virtualusertable: Cannot
allocate memory
If I reboot it goes away but has been reappearing.

I'd like to try limiting the amount of files per process.
By default, I believe Postgres is configured to permit 1000 open files
per process,
and my server currently has 9 postgres processes running.

Is there an option I can configure to do this ??

Many thanks
Regards
Rudi Starcevic


pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: data format problem for upgrede from 7.1->7.3
Next
From: Marek Florianczyk
Date:
Subject: Re: performance problem - 10.000 databases