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
>
>
