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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
