Обсуждение: HA Cluster Solution?
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
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!!!
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
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 > >
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
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 > >
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.