how to set timeout idle connection direct on driver pycopg2 by odoo config?

Question

hello guys, i've question related idle connection because of slow query from odoo to postgre, is it possible we set the timeout from odoo config?
i've read  https://www.odoo.com/forum/help-1/killing-idle-postgres-processes-100613 [1]
and i've done integrate/implement pgbouncer to my odoo instance, and i want to know is there possible set time to killing idle process postgres?
thank you

[1] https://www%5C.odoo%5C.com/forum/help%5C-1/killing%5C-idle%5C-postgres%5C-processes%5C-100613

Moe Sana · Answer

I am having the same issue in mu db also. I tried to install pgbouncer and not working for me. Hope someone can help in this. Can you share please how you setup pgbouncer and configure it as a help.

Thanks

Powiązane posty	Odpowiedzi	Widoki
How can retrieve the production orders with its childs with query select? report query select v14	0 wrz 23	1526
Attached PDF file is not formatted properly v14	1 gru 25	349
Odoo14 alternative for Automated Translations through Gengo API module v14	3 wrz 25	3788
Odoo Community v14 Slow on High-End Servers, Fast on i5/i7 PCs v14	0 sie 25	1179
How to Managing Birthdate and Age in Odoo v14	1 sie 25	3561

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!