From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jim C. Nasby <jim@nasby.net>
Cc: George Pavlov <gpavlov@mynewplace.com>
Cc: Tom Darci <tom@nuws.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: query slows down drastically with increased number of fields
Date: Thu, 26 Oct 2006 18:50:11 -0400
Message-ID: <26740.1161903011@sss.pgh.pa.us> (raw)
In-Reply-To: <20061026223650.GS26892@nasby.net>
References: <6FB011BE26AACD4CB5F2B505AE0BEB2E020B6E86@MI8NYCMAIL05.Mi8.com>
<8C5B026B51B6854CBE88121DBF097A8655C484@ehost010-33.exch010.intermedia.net>
<20061026223650.GS26892@nasby.net>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, jim@nasby.net, gpavlov@mynewplace.com, tom@nuws.com
Subject: Re: query slows down drastically with increased number of fields
In-Reply-To: <26740.1161903011@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox