| From: | Kirk Wythers <kwythers(at)umn(dot)edu> |
|---|---|
| To: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "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:03:54 |
| Message-ID: | 293ED31C-0866-4616-9D44-A22D8111E57C@umn.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Feb 2, 2007, at 7:39 PM, Luke Lonergan wrote:
> Tom,
>
> On 2/2/07 2:18 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> as of 8.2 there's a psql variable
>> FETCH_COUNT that can be set to make it happen behind the scenes.)
>
> FETCH_COUNT is a godsend and works beautifully for exactly this
> purpose.
>
> 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.
>
> - Luke
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-02-03 02:05:21 | Re: trouble with a join on OS X |
| Previous Message | Kirk Wythers | 2007-02-03 02:01:39 | Re: trouble with a join on OS X |