Re: HA Cluster Solution? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: HA Cluster Solution?
Date
Msg-id CAFj8pRD8XQgLQETJ++oEABTUu+5Jq+quVYV629e70=4bFRHKTA@mail.gmail.com
Whole thread Raw
In response to HA Cluster Solution?  (Periko Support <pheriko.support@gmail.com>)
Responses Re: HA Cluster Solution?
List pgsql-general
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

pgsql-general by date:

Previous
From: Periko Support
Date:
Subject: HA Cluster Solution?
Next
From: Geoff Winkless
Date:
Subject: Re: Transactional-DDL DROP/CREATE TABLE