| From: | Kirk Wythers <kwythers(at)umn(dot)edu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Luke Lonergan" <llonergan(at)greenplum(dot)com>, "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>, " " Gábriel Ákos " " <akos(dot)gabriel(at)i-logic(dot)hu>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: trouble with a join on OS X |
| Date: | 2007-02-03 03:19:15 |
| Message-ID: | 7CF821AD-20DA-4CC7-8A05-5B778B164327@umn.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Feb 2, 2007, at 8:32 PM, Tom Lane wrote:
> Kirk Wythers <kwythers(at)umn(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-02-03 03:25:38 | Re: trouble with a join on OS X |
| Previous Message | Joshua D. Drake | 2007-02-03 02:32:26 | Re: trouble with a join on OS X |