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