[Freeswitch-users] Postgresql in fs core: recommendations

[Antonio Silva]

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 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
>
> _________________________________________________________________________
> 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

-- 

Saludos / Regards / Cumprimentos,
António silva