"Mavinakuli, Prasanna (STSD)" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
