[Freeswitch-users] Postgresql in fs core: recommendations

[Michael Jerris]

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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org