Postgresql in fs core: recommendations
Hi, On debian jessie, i've switch from using sqlite in the core with db located at /dev/shm to postgresql server running on the same box, but now for the first time, i see SIP messages in FS "503 Server Busy" and losing endpoint registration with expire, i think the delay added by pg to process the queries affects fs main process to handle huge number of sip messages per second. In terms of fs i have: - call average 6 cps - avg 100 registers / sec (the expire value configure in the accounts is of 300 seconds) - avg 150 options / sec (max of 400 pkt/sec) - avg 50 notify / sec (max of 100 pkt/sec) In fs configurations i've: max-db-handles = 100 max-sessions = 2000 sessions-per-second = 50 My server i think is quite power to handle this traffic: 2 x Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz 32GB of ram sata disk 7200RPM I was wonder if any of you have this issues and if you could share your pg configuration? For now i i've try for pg: max_connections = 100 ssl = false shared_buffers = 5GB dynamic_shared_memory_type = posix Thanks, -- Saludos / Regards / Cumprimentos, António silva
Just hit this link, where it explains how to put pg in ram: http://www.manniwood.com/postgresql_94_in_ram/index.html I guess i could try this to have similar behavior as sqlite. On 01/11/2017 11:38 AM, Antonio Silva wrote:
Hi,
On debian jessie, i've switch from using sqlite in the core with db located at /dev/shm to postgresql server running on the same box, but now for the first time, i see SIP messages in FS "503 Server Busy" and losing endpoint registration with expire, i think the delay added by pg to process the queries affects fs main process to handle huge number of sip messages per second.
In terms of fs i have: - call average 6 cps - avg 100 registers / sec (the expire value configure in the accounts is of 300 seconds) - avg 150 options / sec (max of 400 pkt/sec) - avg 50 notify / sec (max of 100 pkt/sec)
In fs configurations i've: max-db-handles = 100 max-sessions = 2000 sessions-per-second = 50
My server i think is quite power to handle this traffic:
2 x Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz 32GB of ram sata disk 7200RPM
I was wonder if any of you have this issues and if you could share your pg configuration?
For now i i've try for pg:
max_connections = 100 ssl = false shared_buffers = 5GB dynamic_shared_memory_type = posix
Thanks,
-- Saludos / Regards / Cumprimentos, António silva
might need to play w/ doing register in threads. There is a profile param for this.
On Jan 11, 2017, at 5:38 AM, Antonio Silva <asilva@wirelessmundi.com> wrote:
Hi,
On debian jessie, i've switch from using sqlite in the core with db located at /dev/shm to postgresql server running on the same box, but now for the first time, i see SIP messages in FS "503 Server Busy" and losing endpoint registration with expire, i think the delay added by pg to process the queries affects fs main process to handle huge number of sip messages per second.
In terms of fs i have: - call average 6 cps - avg 100 registers / sec (the expire value configure in the accounts is of 300 seconds) - avg 150 options / sec (max of 400 pkt/sec) - avg 50 notify / sec (max of 100 pkt/sec)
In fs configurations i've: max-db-handles = 100 max-sessions = 2000 sessions-per-second = 50
My server i think is quite power to handle this traffic:
2 x Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz 32GB of ram sata disk 7200RPM
I was wonder if any of you have this issues and if you could share your pg configuration?
For now i i've try for pg:
max_connections = 100 ssl = false shared_buffers = 5GB dynamic_shared_memory_type = posix
Thanks,
--
Saludos / Regards / Cumprimentos, António silva
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Hi, yes already set it: <param name="max-reg-threads" value="8"/> <param name="inbound-reg-in-new-thread" value="true"/> The only change here is from sqlite to postgresql, for sure that is some tunning in pg to handle this volume of traffic... i'm still trying to figure it out. On 01/11/2017 04:17 PM, Michael Jerris wrote:
might need to play w/ doing register in threads. There is a profile param for this.
On Jan 11, 2017, at 5:38 AM, Antonio Silva <asilva@wirelessmundi.com> wrote:
Hi,
On debian jessie, i've switch from using sqlite in the core with db located at /dev/shm to postgresql server running on the same box, but now for the first time, i see SIP messages in FS "503 Server Busy" and losing endpoint registration with expire, i think the delay added by pg to process the queries affects fs main process to handle huge number of sip messages per second.
In terms of fs i have: - call average 6 cps - avg 100 registers / sec (the expire value configure in the accounts is of 300 seconds) - avg 150 options / sec (max of 400 pkt/sec) - avg 50 notify / sec (max of 100 pkt/sec)
In fs configurations i've: max-db-handles = 100 max-sessions = 2000 sessions-per-second = 50
My server i think is quite power to handle this traffic:
2 x Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz 32GB of ram sata disk 7200RPM
I was wonder if any of you have this issues and if you could share your pg configuration?
For now i i've try for pg:
max_connections = 100 ssl = false shared_buffers = 5GB dynamic_shared_memory_type = posix
Thanks,
--
Saludos / Regards / Cumprimentos, António silva
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Saludos / Regards / Cumprimentos, António silva
participants (2)
-
Antonio Silva
-
Michael Jerris