Re: [GENERAL] User-defined Aggregate function and performance.

2012-04-03 Thread Ronan Dunklau
On 02/04/2012 18:06, Tom Lane wrote: > Ronan Dunklau writes: >> I'm trying to define a "weighted mean" aggregate using postgresql create >> aggregate feature. > >> I've been able to quickly write the required pgsql code to get it >> working, but after testing it on a sample 1 rows table, it se

Re: [GENERAL] User-defined Aggregate function and performance.

2012-04-02 Thread Tom Lane
Ronan Dunklau writes: > I'm trying to define a "weighted mean" aggregate using postgresql create > aggregate feature. > I've been able to quickly write the required pgsql code to get it > working, but after testing it on a sample 1 rows table, it seems to > be approximately 6 to 10 times slow