Re: Too many open files from postgres. - Mailing list pgsql-general

From Tom Lane
Subject Re: Too many open files from postgres.
Date
Msg-id 10020.1155182765@sss.pgh.pa.us
Whole thread Raw
In response to Too many open files from postgres.  ("Mavinakuli, Prasanna (STSD)" <prasanna.b-m@hp.com>)
List pgsql-general
"Mavinakuli, Prasanna (STSD)" <prasanna.b-m@hp.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

pgsql-general by date:

Previous
From: "Harpreet Dhaliwal"
Date:
Subject: Re: Connection string
Next
From: Steve Atkins
Date:
Subject: Re: Accessing Database Data from C Function