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

Odoo/PostgreSQL optimization

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
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 <dave@laslabs.com>:
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

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe


--
Dr.-Ing. Frederik Kramer
Geschäftsführer
        
initOS GmbH
An der Eisenbahn 1
21224 Rosengarten
        
Phone:  +49 4105 56156-12
Fax:    +49 4105 56156-10
Mobil:  +49 179 3901819
        
Email: frederik.kramer@initos.com
Web:   www.initos.com
        
Geschäftsführung:
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

Reference