Skip site navigation (1) Skip section navigation (2)

Re: query slows down drastically with increased number of fields

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 (view raw or flat)
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

In response to

pgsql-performance by date

Next:From: Tom DarciDate: 2006-10-27 00:01:19
Subject: Re: query slows down drastically with increased number of
Previous:From: Jim C. NasbyDate: 2006-10-26 22:36:50
Subject: Re: query slows down drastically with increased number of fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group