| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
| Cc: | George Pavlov <gpavlov(at)mynewplace(dot)com>, Tom Darci <tom(at)nuws(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: query slows down drastically with increased number of fields |
| Date: | 2006-10-26 22:50:11 |
| Message-ID: | 26740.1161903011@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Jim C. Nasby" <jim(at)nasby(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Darci | 2006-10-27 00:01:19 | Re: query slows down drastically with increased number of |
| Previous Message | Jim C. Nasby | 2006-10-26 22:36:50 | Re: query slows down drastically with increased number of fields |