Contributors mailing list archives


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

InitOS GmbH, Frederik Kramer
- 09/11/2017 23:18:24
For us putting the stuff in SSDs offen helped a lot and Indexes are your friends

Am 9. November 2017 18:48:44 MEZ schrieb Dave Lasley <>:
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

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 <> 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.

Jordi Ballester Alomar
CEO & Founder | Eficent

Post to:

Dr.-Ing. Frederik Kramer
initOS GmbH
An der Eisenbahn 1
21224 Rosengarten
Phone:  +49 4105 56156-12
Fax:    +49 4105 56156-10
Mobil:  +49 179 3901819
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr.: DE815580155