Re: Out of file-descriptors message

Alvaro Herrera wrote:
> John Allgood wrote:
>
>> Hey Tom
>>
>>     I assume that if it is the kernel running out of descriptors that I
>> would get the messages in dmesg. This message only appears in the log
>> file for that database.
>>
>
> Yeah, the point is that you have the max_files_per_process setting
> higher than what the kernel likes.  So decrease it, and Postgres will
> adjust itself to use less file descriptors by closing and reopening
> files as needed.
>
>
I really can't see that is possible file-max is set to 838860. I believe
it is based on the amount of ram on the machine and we have 8GB. ulimit
-a reports you can have 1024 open files. I thought maybe we were running
out of descriptors for the postgres user but that should not bring down
the machine. Thoughts anyone.