Re: Terrible performance on wide selects

Steve Crawford <scrawford(at)pinpointresearch(dot)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