I'm trying to get better numbers, is a option in the table. Meanwhile I reading some system performance numbers. Yes odoo is strange sometimes. But a cluster will be good for HA. Thanks. On Mon, Oct 10, 2016 at 11:12 AM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: > Hi > > 2016-10-10 17:20 GMT+02:00 Periko Support <pheriko.support@xxxxxxxxx>: >> >> I have done some tuning for psql base on odoo, but I want to know if a >> cluster can help to get a better performance, this why I ask here in >> the community who has experience with clusters. >> Appreciate your help Pavel. > > > It is hard to say if cluster helps - depends on data size - but odoo > produces really strange queries - I am little bit sceptic. But I am sure, so > cluster increase significantly maintenance costs. > > Regards > > Pavel > >> >> >> On Sun, Oct 9, 2016 at 9:29 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> >> wrote: >> > Hi >> > >> > 2016-10-10 6:22 GMT+02:00 Periko Support <pheriko.support@xxxxxxxxx>: >> >> >> >> Hi. >> >> >> >> We are searching for a cluster solutions for postgresql, we need to >> >> increase our current psql server performance running under ubuntu 14 >> >> v9.3. >> >> >> >> The db is for odoo 7.x >> > >> > >> > I have some experience with odoo 7.x - there are lot of pretty slow >> > queries >> > without good possibility of optimization. More - there are some articles >> > on >> > net that advices suboptimal configuration of Postgres, of odoo. >> > >> > If you can, you can try to upgrade to PostgreSQL 9.6 - more CPU per >> > query >> > can help, or you can upgrade to new odoo (I have not real experience, >> > but >> > the web speak about lot of optimization). >> > >> > If you have some own customization, look to slow queries - lot of >> > performance issues can be fixed. >> > >> > Regards >> > >> > Pavel >> > >> > >> > >> >> >> >> >> >> Reading on psql doc cluster, exist different solutions like >> >> postgresql-xl, pgpool which are more for clustering. >> >> >> >> In your experience what psql tools for clustering and HA have give >> >> u good performance. >> >> >> >> Any comment are welcome, thanks for your time!!! >> >> >> >> >> >> -- >> >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> >> To make changes to your subscription: >> >> http://www.postgresql.org/mailpref/pgsql-general >> > >> > >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
