Re: [GENERAL] array_agg performance

2009-10-09 Thread Tom Lane
"Spotts, Christopher" writes: > Using postgres 8.4.1, I thought the upgrade from 8.4.0 would help with > array_agg. > Using ARRAY() with a subselect is yielding results hundreds times faster > than array_agg even though its plan looks much worse... Huh, you sure your server is on 8.4.1? I can'

[GENERAL] array_agg performance

2009-10-09 Thread Spotts, Christopher
Using postgres 8.4.1, I thought the upgrade from 8.4.0 would help with array_agg. Using ARRAY() with a subselect is yielding results hundreds times faster than array_agg even though its plan looks much worse... And the entire system is seriously slugglish and near non-responsive while running th