From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kirk Wythers <kwythers@umn.edu>
Cc: Luke Lonergan <llonergan@greenplum.com>
Cc: Steinar H. Gunderson <sgunderson@bigfoot.com>
Cc: " Gábriel Ákos " <akos.gabriel@i-logic.hu>
Cc: pgsql-performance@postgresql.org
Subject: Re: trouble with a join on OS X
Date: Fri, 02 Feb 2007 21:32:12 -0500
Message-ID: <26430.1170469932@sss.pgh.pa.us> (raw)
In-Reply-To: <293ED31C-0866-4616-9D44-A22D8111E57C@umn.edu>
References: <C1E927EA.1A0FC%llonergan@greenplum.com>
<293ED31C-0866-4616-9D44-A22D8111E57C@umn.edu>
Kirk Wythers <kwythers@umn.edu> writes:
> On Feb 2, 2007, at 7:39 PM, Luke Lonergan wrote:
>> Now he's got to worry about how to page through 8GB of results in
>> something less than geological time with the space bar ;-)
> I actually have no intention of paging through the results, but
> rather need to use the query to get the results into a new table with
> UPDATE, so that a GIS system can do some interpolations with subsets
> of the results.
Er ... then why are you SELECTing the data at all? You can most likely
get it done much faster if the data stays inside the database engine.
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, kwythers@umn.edu, llonergan@greenplum.com, sgunderson@bigfoot.com, akos.gabriel@i-logic.hu
Subject: Re: trouble with a join on OS X
In-Reply-To: <26430.1170469932@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