From: Jim C. Nasby <jim@nasby.net>
To: 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 17:36:50 -0500
Message-ID: <20061026223650.GS26892@nasby.net> (raw)
In-Reply-To: <8C5B026B51B6854CBE88121DBF097A8655C484@ehost010-33.exch010.intermedia.net>
References: <6FB011BE26AACD4CB5F2B505AE0BEB2E020B6E86@MI8NYCMAIL05.Mi8.com>
<8C5B026B51B6854CBE88121DBF097A8655C484@ehost010-33.exch010.intermedia.net>
On Thu, Oct 26, 2006 at 03:03:38PM -0700, George Pavlov wrote:
> i have wondered myself. i wouldn't do it through pgAdmin (not sure what
> the best test it, but i thought psql from the same machine might be
> better--see below). 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.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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: jim@nasby.net, gpavlov@mynewplace.com, tom@nuws.com
Subject: Re: query slows down drastically with increased number of fields
In-Reply-To: <20061026223650.GS26892@nasby.net>
* 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