"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'
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