Re: [GENERAL] HA Cluster Solution?

2016-10-09 Thread Pavel Stehule
Hi 2016-10-10 6:22 GMT+02:00 Periko Support : > 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 p

[GENERAL] HA Cluster Solution?

2016-10-09 Thread Periko Support
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.

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Sebastian P . Luque
On Sun, 09 Oct 2016 16:00:21 -0400, Tom Lane wrote: > "Sebastian P. Luque" writes: >> Tom Lane wrote: >>> On closer inspection, the error is only in the >>> aggregate-used-as-window-function case, not plain aggregation. >> Yes, I see the same phenomenon. Could someone suggest a workaround >>

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Adrian Klaver
On 10/09/2016 09:40 AM, Tom Lane wrote: Adrian Klaver writes: On 10/09/2016 08:46 AM, Tom Lane wrote: Clearly a bug --- the wrong type OIDs are being passed down to array_append. It should be told that it's getting called as For my edification, why does this work?: On closer inspection,

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Tom Lane
"Sebastian P. Luque" writes: > Tom Lane wrote: >> On closer inspection, the error is only in the >> aggregate-used-as-window-function case, not plain aggregation. > Yes, I see the same phenomenon. Could someone suggest a workaround > until this is fixed? I'm under the gun to submit output tabl

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Sebastian P . Luque
On Sun, 09 Oct 2016 12:40:09 -0400, Tom Lane wrote: > Adrian Klaver writes: >> On 10/09/2016 08:46 AM, Tom Lane wrote: >>> Clearly a bug --- the wrong type OIDs are being passed down to >>> array_append. It should be told that it's getting called as >> For my edification, why does this work?:

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Tom Lane
Adrian Klaver writes: > On 10/09/2016 08:46 AM, Tom Lane wrote: >> Clearly a bug --- the wrong type OIDs are being passed down to >> array_append. It should be told that it's getting called as > For my edification, why does this work?: On closer inspection, the error is only in the aggregate-us

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Adrian Klaver
On 10/09/2016 08:46 AM, Tom Lane wrote: Seb writes: Any thoughts on what has changed that is leading to this failure? Clearly a bug --- the wrong type OIDs are being passed down to array_append. It should be told that it's getting called as (angle_vectors[], angle_vectors) returns a

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Tom Lane
Seb writes: > Any thoughts on what has changed that is leading to this failure? Clearly a bug --- the wrong type OIDs are being passed down to array_append. It should be told that it's getting called as (angle_vectors[], angle_vectors) returns angle_vectors[] but what it's actually get

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Adrian Klaver
On 10/09/2016 08:01 AM, Sebastian P. Luque wrote: On Sun, 9 Oct 2016 06:44:10 -0700, Adrian Klaver wrote: [...] Not sure. When I tried using the above(on 9.5) it failed during the CREATE OR REPLACE FUNCTION public.angle_vectors_avg stage with: ERROR: type "vector" does not exist So whe

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Sebastian P . Luque
On Sun, 9 Oct 2016 06:44:10 -0700, Adrian Klaver wrote: [...] > Not sure. When I tried using the above(on 9.5) it failed during the > CREATE OR REPLACE FUNCTION public.angle_vectors_avg stage with: > ERROR: type "vector" does not exist > So where is that coming from in your setup? Aw nuts, I

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Adrian Klaver
On 10/08/2016 08:21 PM, Seb wrote: Hello, Until I upgraded to PostgreSQL 9.6, a custom average function was working well as a window function. It's meant to average a composite type: CREATE TYPE public.angle_vectors AS (x double precision, y double precision); COMMENT ON TYPE public.ang