"Mavinakuli, Prasanna (STSD)" <prasanna(dot)b-m(at)hp(dot)com> writes:
> We have observed that postgres opens many files in data directory
> And won't close till next vacuum (I experience it)
> When it hits max limit, we won't able to open any other files.
> So what's the solution ..?
Reduce PG's max_files_per_process setting, or increase your kernel's
max-number-of-open-files limit.
regards, tom lane