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

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

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kế toán
Tồn kho
PoS
Project
MRP

All apps

Tất cả bài viết Người Huy hiệu

Thẻ (Xem tất cả)

odoo accounting v14 pos v15

Về diễn đàn này

Hỗ trợ

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

query slowness v14

1 Trả lời

2266 Lượt xem

rehan

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

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

Moe Sana

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

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!

Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!

Đăng ký

Bài viết liên quan	Trả lời	Lượt xem
How can retrieve the production orders with its childs with query select? report query select v14	0 thg 9 23	1045
Odoo14 alternative for Automated Translations through Gengo API module v14	1 thg 7 25	2319
Update Initial Stock of Product using XMLRPC API [Odoo14] Đã xử lý v14	2 thg 7 25	7798
"AttributeError: 'NoneType' object has no attribute 'CompileError'" configuring document Layout - Odoo 14 v14	2 thg 7 25	4199
In user settings access group check box changed to list view how can i change back it to checkbox v14	2 thg 7 25	3987

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!