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

相關帖文	回覆	瀏覽次數
How can retrieve the production orders with its childs with query select? report query select v14	0 9月 23	1039
Odoo14 alternative for Automated Translations through Gengo API module v14	1 7月 25	2304
Update Initial Stock of Product using XMLRPC API [Odoo14] 已解決 v14	2 7月 25	7773
"AttributeError: 'NoneType' object has no attribute 'CompileError'" configuring document Layout - Odoo 14 v14	2 7月 25	4189
In user settings access group check box changed to list view how can i change back it to checkbox v14	2 7月 25	3971

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！