From: | "Geo P(dot)C(dot)" <pcgeopc(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Too many Open files error for postgres |
Date: | 2016-06-22 13:41:03 |
Message-ID: | CAKtc8vWo4Hs14v60oBpMN2ZzbQV+9CzUc64Zok7pFy7ruFkw-A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks a lot.. We are able to fix the issue with it by reducing
max_files_per_process to 500 from default 1000..
This paramater "Sets the maximum number of simultaneously open files
allowed to each server subprocess". So in postgres it means it reduces the
number of open files limit. If possible can you please refine what it
actually does?
* <http://pcgeo.blogspot.in/>*
On Tue, Jun 21, 2016 at 7:39 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Geo P.C." <pcgeopc(at)gmail(dot)com> writes:
> > In Ubuntu 14.04 server on a JAVA Application we are getting Too many Open
> > files error for postgres.
>
> How many server processes are you trying to use? I suspect you are
> hitting the system-wide file table limit not the per-process limit.
> Best answer might be to decrease PG's max_files_per_process setting
> rather than try to persuade the kernel to increase its limit.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Campbell, Lance | 2016-06-22 15:50:49 | Log says temporary files are being created |
Previous Message | Keith | 2016-06-21 15:37:18 | Re: WAL retention |