| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Kirk Wythers <kwythers(at)umn(dot)edu> |
| 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 02:32:12 |
| Message-ID: | 26430.1170469932@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-02-03 02:32:26 | Re: trouble with a join on OS X |
| Previous Message | Geoffrey | 2007-02-03 02:10:21 | Re: trouble with a join on OS X |