Number of open files

Поиск
Список
Период
Сортировка
От Mark Alliban
Тема Number of open files
Дата
Msg-id 95bofm$sop$1@news.tht.net
обсуждение исходный текст
Ответы Re: Number of open files  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

I am having problems with the number of open files on Redhat 6.1. The value
of /proc/sys/fs/file-max is 4096 (the default), but this value is reached
with about 50 ODBC connections. Increasing the file-max value would only
temporarily improve matters because on the long-term I expect to have 500+
active connections. How comes there are so many open files per connection?
Is there any way to decrease the number of open files, so that I don't have
to increase file-max to immense proportions?

Thanks,
Mark.



В списке pgsql-general по дате отправления:

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: [NOVICE] Re: Sizing of LARGE databases.
Следующее
От: "Ian deSouza"
Дата:
Сообщение: Dates/Timestamps in a where clause