1. Mailing Lists
  2. Contributors
  3. Re: Performance issues for all users in Odoo 9 when a single user creates a heavy request

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: Performance issues for all users in Odoo 9 when a single user creates a heavy request

Avatar

Re: Performance issues for all users in Odoo 9 when a single user creates a heavy request

by
LasLabs, Dave Lasley
- 09/11/2017 18:39:07
Assuming you’re running Odoo using workers, and the none of the servers are experiencing load (particularly IO or CPU) - I recommend checking the Postgres locks during an incident https://wiki.postgresql.org/wiki/Lock_Monitoring

Also your standard Postgres tuning:


Not sure what monitoring you have in place, but we use PgWatch2 inside of Grafana for high level database stuff.

— Dave Lasley

On Nov 9, 2017, at 9:32 AM, Jordi Ballester Alomar <jordi.ballester@eficent.com> wrote:

Dear contributors,

We have often found a problem of performance that starts when a user triggers a heavy request - e.g. executing a long, heavy accounting report - this seems to be negatively impacting to the performance of other users. 

I would appreciate if someone can help me to get to know a bit more what can be the possible cause of this. Performance issue in Postgres? In Odoo?

We are putting together various performance metrics to better understand the potential causes according to the various Odoo performance guidelines that Odoo has been publishing in the past.

Regards,
--
Jordi Ballester Alomar
CEO & Founder | Eficent

Reference