Re: "Too many open files in system" error - Mailing list pgsql-admin

From Tom Lane
Subject Re: "Too many open files in system" error
Date
Msg-id 7232.1250175551@sss.pgh.pa.us
Whole thread Raw
In response to Re: "Too many open files in system" error  (Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>)
List pgsql-admin
Jonatan Evald Buus <jonatan.buus@cellpointmobile.com> writes:
> Also, what would a reasonable setting for "max_files_per_process" based on a
> machine with 2GB RAM running FreeBSD 7.1 be?
> The comments mention that "max_files_per_process may" be set as low as 25
> but what would the implications of this restriction be?

At some point you're going to start losing performance because of too
many close() and open() calls that have to be issued to switch a small
number of file descriptors around to different tables.  AFAIK no one
has really tried to measure the issue.  Personally I'd be pretty
concerned about setting it to less than 100 or so.

            regards, tom lane

pgsql-admin by date:

Previous
From: th@gesteam.fr
Date:
Subject: Get current_user in statistics
Next
From: Ray Stell
Date:
Subject: VACUUM WARNING: skipping