Max open files

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Max open files
Date: 2018-09-18 10:03:07
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A082D27F19C02@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

i am using Bind-DLZ with postgresql and i am experiencing some response problem with a number of concurrent queries above 1000 (about).
We use named pipe to connect from Bind DLZ.
I noticed that Postgresql 9.6.1 is launched with a max open files.

Could be this the problem?
How can i raise the limit?

The kernel max files is 999999
Thank you!
F

[root(at)cloud-frankfurt-dns01 pgsql]# cat /proc/5336/limits
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size 0 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 31206 31206 processes
Max open files 1024 4096 files
Max locked memory 65536 65536 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 31206 31206 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2018-09-18 10:27:56 Code of Conduct
Previous Message Nordström Thomas 2018-09-18 09:24:36 Issues with compiling libpq 9.1.2 with Visual C++