[Freeswitch-users] Postgresql in fs core: recommendations

[Antonio 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