X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4BC1C329E01 for ; Mon, 13 Sep 2004 14:44:54 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98387-06 for ; Mon, 13 Sep 2004 13:44:46 +0000 (GMT) Received: from mailserv.mobilecohesion.com (picard.mobilecohesion.com [80.4.157.11]) by svr1.postgresql.org (Postfix) with ESMTP id C7C0C329E6C for ; Mon, 13 Sep 2004 14:44:48 +0100 (BST) Received: from cpc1-blfs1-3-0-cust245.blfs.cable.ntl.com ([213.107.97.245] helo=a31p005) by mailserv.mobilecohesion.com with asmtp (Exim 4.10) id 1C6r8O-0008DA-00 for pgsql-performance@postgresql.org; Mon, 13 Sep 2004 14:44:44 +0100 From: "Damien Dougan" To: Subject: Re: Help with extracting large volumes of records across related tables Date: Mon, 13 Sep 2004 14:44:45 +0100 Organization: Mobile Cohesion Message-ID: <005801c49997$d4a91a20$6e01a8c0@a31p005> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: Importance: Normal X-MobileCohesion-MailScanner-Information: Please contact the ISP for more information X-MobileCohesion-MailScanner: Found to be clean X-MailScanner-From: damien.dougan@mobilecohesion.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/87 X-Sequence-Number: 8215 Pierre-Frederic, Paul, Thanks for your fast response (especially for the python code and performance figure) - I'll chase this up as a solution - looks most promising! Cheers, Damien