HA Cluster Solution?

Hi

2016-10-10 6:22 GMT+02:00 Periko Support <pheriko.support@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

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.

On Sun, Oct 9, 2016 at 9:29 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:

Hi

2016-10-10 6:22 GMT+02:00 Periko Support <pheriko.support@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

Hi

2016-10-10 17:20 GMT+02:00 Periko Support <pheriko.support@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

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@gmail.com> wrote:

Hi

2016-10-10 17:20 GMT+02:00 Periko Support <pheriko.support@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.stehule@gmail.com>
wrote:

Hi

2016-10-10 6:22 GMT+02:00 Periko Support <pheriko.support@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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 10 October 2016 21:14:55 CEST, Periko Support <pheriko.support@gmail.com> wrote:

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.

Please identify the problematic queries ( for instance using pg_stat_statements) and send this to the team behind odoo.

Andreas.
--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general