Re: "Too many open files in system" error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "Too many open files in system" error
Дата
Msg-id 7232.1250175551@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "Too many open files in system" error  (Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>)
Список 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 по дате отправления:

Предыдущее
От: th@gesteam.fr
Дата:
Сообщение: Get current_user in statistics
Следующее
От: Ray Stell
Дата:
Сообщение: VACUUM WARNING: skipping