Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1E8CF9FA18C for ; Fri, 2 Feb 2007 21:40:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 93967-02 for ; Fri, 2 Feb 2007 21:40:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exprod6og54.obsmtp.com (exprod6og54.obsmtp.com [64.18.1.189]) by postgresql.org (Postfix) with SMTP id 94EB29FA176 for ; Fri, 2 Feb 2007 21:40:30 -0400 (AST) Received: from source ([63.240.6.44]) (using TLSv1) by exprod6ob54.postini.com ([64.18.5.12]) with SMTP; Fri, 02 Feb 2007 17:40:26 PST Received: from 172.16.1.92 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Fri, 02 Feb 2007 20:39:57 -0500 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL08.Mi8.com ([172.16.1.164]) by d01smtp08.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 2 Feb 2007 20:39:56 -0500 Received: from 63.80.24.130 ([63.80.24.130]) by MI8NYCMAIL08.Mi8.com ( [172.16.1.190]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.134]) with Microsoft Exchange Server HTTP-DAV ; Sat, 3 Feb 2007 01:39:56 +0000 User-Agent: Microsoft-Entourage/11.3.3.061214 Date: Fri, 02 Feb 2007 17:39:54 -0800 Subject: Re: trouble with a join on OS X From: "Luke Lonergan" To: "Tom Lane" , "Kirk Wythers" cc: "Steinar H. Gunderson" , "G=?ISO-8859-1?B?4Q==?=briel =?ISO-8859-1?B?wQ==?=kos" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] trouble with a join on OS X Thread-Index: AcdHNDQFcp40JbMnEduqxQAWy4o9DA== In-Reply-To: <24768.1170454736@sss.pgh.pa.us> MIME-Version: 1.0 X-OriginalArrivalTime: 03 Feb 2007 01:39:56.0855 (UTC) FILETIME=[35B93470:01C74734] X-WSS-ID: 69DD38673C813826887-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/31 X-Sequence-Number: 23085 Tom, On 2/2/07 2:18 PM, "Tom Lane" 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