Hi Alex,
That is clear. I decreased the max worker processes to 20 to be on the safe side. But what
is confusing me is what about the 18 worker processes ran by Kamailio, will they overlap
with postgres processes or they are the same , knowing that Kamailio role in my case is
just getting routing decision by running a query on the database and send it back to the
SBC. Excuse my lack of knowledge in how linux processes work.
Regards,
Ali Taher
-----Original Message-----
From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of Alex Balashov
Sent: Tuesday, September 1, 2020 8:22 PM
To: sr-users(a)lists.kamailio.org
Subject: Re: [SR-Users] worker processes
On 2020-09-01 12:08, Ali Taher wrote:
I noticed that there is 48 database connections
established by
Kamailio
(16 x 3) , can this cause an issue knowing that maximum worker
processes is 24 ?
Postgres's ability to serve clients and accommodate queries
isn't limited by the number of max_worker_processes. The default is 8 if this value is
unset, yet any stock PostgreSQL instance can accommodate more than 8 concurrent
connections, clearly. max_worker_processes != max_connections.
As far as the wisdom of setting process limits to equal the number of available CPU cores
("VCPUs"), there's no absolute answer to that. The general danger with doing
this is just that a particularly expensive or destructive statement can consume all of the
hardware resources, with no safety margins for other processes, and perhaps not even
enough for someone to log in and resolve the problem. So, the general recommendation is
not allow PostgreSQL to consume every single VCPU or max out any other resource, and
that's why most Linux distributions'
server packages come with these types of settings conservatively tuned.
-- Alex
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web:
http://www.evaristesys.com/,
http://www.csrpswitch.com/
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users