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 CE5F3329DB0 for ; Mon, 13 Sep 2004 13:12:02 +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 62943-05 for ; Mon, 13 Sep 2004 12:11:55 +0000 (GMT) Received: from curry.tmsl.demon.co.uk (tmsl-adsl.demon.co.uk [80.177.114.181]) by svr1.postgresql.org (Postfix) with ESMTP id 38395329C82 for ; Mon, 13 Sep 2004 13:11:57 +0100 (BST) Received: from bacon.tmsl.demon.co.uk (bacon.tmsl.demon.co.uk [192.168.7.102]) by curry.tmsl.demon.co.uk (8.11.6/8.11.6) with ESMTP id i8DCAv831388; Mon, 13 Sep 2004 13:11:25 +0100 Date: Mon, 13 Sep 2004 13:10:23 +0100 From: Paul Thomas To: Damien Dougan Cc: pgsql-performance@postgresql.org Subject: Re: Help with extracting large volumes of records across related tables Message-ID: <20040913131023.A6743@bacon> References: <004b01c49986$228c3d60$6e01a8c0@a31p005> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <004b01c49986$228c3d60$6e01a8c0@a31p005>; from damien.dougan@mobilecohesion.com on Mon, Sep 13, 2004 at 12:38:05 +0100 X-Mailer: Balsa 1.2.3 Lines: 17 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/84 X-Sequence-Number: 8212 On 13/09/2004 12:38 Damien Dougan wrote: > [snip] > Are there any tools/tricks/tips with regards to extracting large volumes > of data across related tables from Postgres? It doesnt have to export > into XML, we can do post-processing on the extracted data as needed - > the important thing is to keep the relationship between PvA and PvB on a > row-by-row basis. Have you considered using cursors? -- Paul Thomas +------------------------------+-------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+-------------------------------------------+