Steve Crawford <scrawford@pinpointresearch.com> writes:
> So the question is, does it seem reasonable that a query on fundamentally
> identical data should take 70-90 times as long when displayed as individual
> columns vs. when output as a raw array and, more imporantly, what can I do to
> get acceptable performance on this query?
There are undoubtedly some places that are O(N^2) in the number of
targetlist items. Feel free to do some profiling to identify them.
It probably won't be real hard to fix 'em once identified.
regards, tom lane