Re: trouble with a join on OS X

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

In response to

Responses

Browse pgsql-performance by date

  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