Hi 2016-10-10 17:20 GMT+02:00 Periko Support <pheriko.supp...@gmail.com>:
> 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.steh...@gmail.com> > wrote: > > Hi > > > > 2016-10-10 6:22 GMT+02:00 Periko Support <pheriko.supp...@gmail.com>: > >> > >> 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@postgresql.org) > >> To make changes to your subscription: > >> http://www.postgresql.org/mailpref/pgsql-general > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
