Re: trouble with a join on OS X

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Kirk Wythers" <kwythers(at)umn(dot)edu>
Cc: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>, "G=?ISO-8859-1?B?4Q==?=briel =?ISO-8859-1?B?wQ==?=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 01:39:54
Message-ID: C1E927EA.1A0FC%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

- Luke

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2007-02-03 01:48:38 Re: trouble with a join on OS X
Previous Message Tom Lane 2007-02-02 22:18:56 Re: trouble with a join on OS X