Re: HA Cluster Solution?

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
>