Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2007-02-03 02:05:21
Subject: Re: trouble with a join on OS X
Previous:From: Kirk WythersDate: 2007-02-03 02:01:39
Subject: Re: trouble with a join on OS X

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group