Re: query slows down drastically with increased number of fields

"Jim C. Nasby" <jim@nasby.net> writes:
> On Thu, Oct 26, 2006 at 03:03:38PM -0700, George Pavlov wrote:
>> anyway, the funny thing is that if you concatenate
>> them the time drops:

> Sure. Take a look at the output and you'll see there's less data to
> shove around.

Even more to the point, psql's time to format its standard ASCII-art
output is proportional to the number of columns, because it has to
determine how wide to make each one ... if you used one of the other
display formats such as "expanded" or "unaligned" mode, there's probably
be less difference.

            regards, tom lane