Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 221739FB2AC for ; Fri, 2 Feb 2007 22:33:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 11523-08 for ; Fri, 2 Feb 2007 22:32:46 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 251D39FB28D for ; Fri, 2 Feb 2007 22:32:57 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l132WC6S026431; Fri, 2 Feb 2007 21:32:12 -0500 (EST) To: Kirk Wythers cc: "Luke Lonergan" , "Steinar H. Gunderson" , "=?ISO-8859-1?Q? " G=E1briel_=C1kos " ?=" , pgsql-performance@postgresql.org Subject: Re: trouble with a join on OS X In-reply-to: <293ED31C-0866-4616-9D44-A22D8111E57C@umn.edu> References: <293ED31C-0866-4616-9D44-A22D8111E57C@umn.edu> Comments: In-reply-to Kirk Wythers message dated "Fri, 02 Feb 2007 20:03:54 -0600" Date: Fri, 02 Feb 2007 21:32:12 -0500 Message-ID: <26430.1170469932@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.419 tagged_above=0 required=5 tests=AWL, BAD_ENC_HEADER, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/39 X-Sequence-Number: 23093 Kirk Wythers writes: > On Feb 2, 2007, at 7:39 PM, Luke Lonergan wrote: >> 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. Er ... then why are you SELECTing the data at all? You can most likely get it done much faster if the data stays inside the database engine. regards, tom lane