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: | Raw Message | Whole Thread | 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 |