Community mailing list archives

RE: postgresql idle threads from odoo

Qingdao Oudu Software Co.,Ltd, Cui Jianping / Jason
- 09/10/2015 04:58:09

Many thanks for the input, André. It helps.


From: [] On Behalf Of André P.
Sent: Thursday, September 10, 2015 4:35 PM
To: Community
Subject: Re: postgresql idle threads from odoo


That has been our experience as well - Odoo opens up new connections when it gets many requests at once, but then never frees them up.

Our solution was to put PgBouncer (with Transaction Pooling) between Odoo and Postgres; that said, this solution disables support for some of Postgres features, so it might not work for you if you're doing something more advanced.


2015-09-10 8:35 GMT+01:00 Qingdao Odoo Tech <>:

Hi all,


Not sure if this is the right place to raise this question. Please correct me if I am wrong.


We are facing problems with Odoo server today which popped up 404 Not Found errors. Users were then diverted to another hosting server. After the original hosting server was rebooted, too many idle threads were discovered which were not noticed before. Here is a snapshot of memory usage.


I wonder if anybody has such experience, and your comments are highly appreciated.




Jason Cui

Qingdao Odoo Team


Post to:


<img border=0 width=212 height=212 id="_x0000_i1025" src="cid:image001.jpg@01D0EBE9.DF19C620" alt="图像已被发件人删除。">图像已被发件人删除。

<img border=0 width=15 height=15 id="_x0000_i1027" src="cid:image002.jpg@01D0EBE9.DF19C620" alt="图像已被发件人删除。">


André Paramés

<img border=0 width=20 height=20 id="_x0000_i1028" src="cid:image003.jpg@01D0EBE9.DF19C620" alt="图像已被发件人删除。">


<img border=0 width=275 height=47 id="_x0000_i1029" src="cid:image004.jpg@01D0EBE9.DF19C620" alt="图像已被发件人删除。">


m  +351 939 158 257

LISBOA | Avenida das Túlipas, nº 6, 13º A/B  1495-161 Algés

Post to: