Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E77451337B81 for ; Thu, 4 Nov 2010 11:31:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 71873-04 for ; Thu, 4 Nov 2010 14:31:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from rome.boulder.noaa.gov (rome.boulder.noaa.gov [140.172.10.146]) by mail.postgresql.org (Postfix) with ESMTP id CB5951337B80 for ; Thu, 4 Nov 2010 11:31:24 -0300 (ADT) Received: from [137.75.201.47] (tripledrop.fsl.noaa.gov [137.75.201.47]) by email.boulder.noaa.gov (iPlanet Messaging Server 5.2 HotFix 2.01 (built Aug 26 2004)) with ESMTPA id <0LBD0040E70DJZ@email.boulder.noaa.gov> for pgsql-performance@postgresql.org; Thu, 04 Nov 2010 14:31:25 +0000 (GMT) Date: Thu, 04 Nov 2010 14:31:25 +0000 From: Nick Matheson Subject: Re: Simple (hopefully) throughput question? In-reply-to: <4CD19785.9060301@enterprisedb.com> To: Heikki Linnakangas Cc: pgsql-performance@postgresql.org Message-id: <4CD2C3BD.3030609@noaa.gov> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT User-Agent: Thunderbird 2.0.0.24 (X11/20101005) References: <4CD1853F.2010800@noaa.gov> <4CD19785.9060301@enterprisedb.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/34 X-Sequence-Number: 41058 Heikki- > > Try COPY, ie. "COPY bulk_performance.counts TO STDOUT BINARY". > Thanks for the suggestion. A preliminary test shows an improvement closer to our expected 35 MB/s. Are you familiar with any Java libraries for decoding the COPY format? The spec is clear and we could clearly write our own, but figured I would ask. ;) Nick