"Mavinakuli, Prasanna (STSD)" <prasanna.b-m@xxxxxx> 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
