Re: trouble with a join on OS X - Mailing list pgsql-performance

From Kirk Wythers
Subject Re: trouble with a join on OS X
Date
Msg-id 7CF821AD-20DA-4CC7-8A05-5B778B164327@umn.edu
Whole thread Raw
In response to Re: trouble with a join on OS X  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: trouble with a join on OS X  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: trouble with a join on OS X  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Feb 2, 2007, at 8:32 PM, Tom Lane wrote:

> 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.
>
>

The new table needs to be filled with the results of the join. If
there is a way to do this without a SELECT, please share.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: trouble with a join on OS X
Next
From: "Joshua D. Drake"
Date:
Subject: Re: trouble with a join on OS X