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

[GENERAL] User-defined Aggregate function and performance.

2012-04-02 Thread Ronan Dunklau
Hello. I've tried asking this on the irc channel, without much success. 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 see