[Freeswitch-users] Postgresql in fs core: recommendations

[Antonio Silva]

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