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
I had one simple query that kept crashing the connection. It crashes
after several minutes.
Tried restarting, it still error'd at the same place.
Tried recreating the table it was selecting from, it still error'd at
the same place.
I rewrote the query with an ARRAY subselect and it finished fl
