Re: Postgres connections optimization #4342

Hi,
Thanks for your feedback. Could you tell me how many permanent connections are established based on your setup ? I’ve checked and didn’t found any code update related to connection pool, do you think this could be a feature request ?
Regards,
Stéphane

De : Henning Westerholt <[email protected]>
Date : mercredi, 30 juillet 2025 à 09:07
À : Kamailio (SER) - Users Mailing List <[email protected]>
Cc : Stephane Savonitto <[email protected]>
Objet : RE: Postgres connections optimization #4342
Vous n’obtenez pas souvent d’e-mail à partir de [email protected]. Pourquoi c’est important<https://aka.ms/LearnAboutSenderIdentification>
Hello,

have a look to the actual source of the connections (kamailio PID etc..). In many cases a lot of connections are created during startup and then should expire after some time, because they are not used. The only connections that should stay are from the processed processing actual traffic on external interfaces etc. This is at least the behaviour on MySQL.

Cheers,

Henning

From: Stephane Savonitto via sr-users <[email protected]>
Sent: Dienstag, 29. Juli 2025 17:51
To: [email protected]
Cc: Stephane Savonitto <[email protected]>
Subject: [SR-Users] Postgres connections optimization #4342

Hello,
On P-CSCF when running we have 200+ permanent connection to postgres db, even if there is no traffic. Is there a way to manage connections dynamically using a pool like using PgBouncer ?

Regards,
Stéphane

__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions -- [email protected]
To unsubscribe send an email to [email protected]
Important: keep the mailing list in the recipients, do not reply only to the sender!