Re: HA Cluster Solution?

Hi

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