Re: query slows down drastically with increased number of fields - Mailing list pgsql-performance

From Tom Lane
Subject Re: query slows down drastically with increased number of fields
Date
Msg-id 26740.1161903011@sss.pgh.pa.us
Whole thread Raw
In response to Re: query slows down drastically with increased number of fields  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-performance
"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

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: query slows down drastically with increased number of fields
Next
From: "Tom Darci"
Date:
Subject: Re: query slows down drastically with increased number of