Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
>> I propose we add a new configuration parameter, MAX_FILES_PER_PROCESS,
>> with a default value of about 100. A new backend would set its
>> max-files setting to the smaller of this parameter or
>> sysconf(_SC_OPEN_MAX).
> Seems nice idea. We have been heard lots of problem reports caused by
> ruuning out of the file table.
> However it would be even nicer, if it could be configurable at runtime
> (at the postmaster starting up time) like -N option.
Yes, what I meant was a GUC parameter named MAX_FILES_PER_PROCESS.
You could set it via postmaster.opts or postmaster command line switch.
regards, tom lane