Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 7B2BF1337BCF for ; Thu, 4 Nov 2010 12:07:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 61971-01-3 for ; Thu, 4 Nov 2010 15:07:33 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f46.google.com (mail-bw0-f46.google.com [209.85.214.46]) by mail.postgresql.org (Postfix) with ESMTP id C96BA1337B53 for ; Thu, 4 Nov 2010 12:07:31 -0300 (ADT) Received: by bwz11 with SMTP id 11so1743520bwz.19 for ; Thu, 04 Nov 2010 08:07:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=SjGFcRUmDpcUFFUhPWQjnGpzRmqYbZFDOVd8l82MpJI=; b=HGfsh4OfVGQ/he0/k987+RuM+uc93Zfm2W39OJYmkHCrwykjHs31gr1HGMsxV5Pln4 IRY2tSebuiGFc1ACfI4FQBfD/tBuLOFqPHtSduTS2h+S95GyhHbj/0rwz/gNbQ5t1qLh XcD0FVRXOUgrQLDuLeefRGCsMW6ffGKNI30EU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=tqJiozNw11d+SS7wDbsr1gGo48zQ2C2XoW0GLFlF4S/NeUB8WcUkkl16mWwZJa0pXe 89HXmL964fzMbEKLWmP24KPe7nhssdhvUUaPrzuhcu2IWkQMJuMUYJTFJIKR3K8F113B 7qjmcEKQU882xYoW/2UQip+Saj90P+eom4c/0= Received: by 10.204.83.215 with SMTP id g23mr707850bkl.211.1288883249647; Thu, 04 Nov 2010 08:07:29 -0700 (PDT) Received: from [10.1.1.57] (skuns.zoral.com.ua [91.193.166.194]) by mx.google.com with ESMTPS id m8sm759591faj.1.2010.11.04.08.07.27 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 04 Nov 2010 08:07:28 -0700 (PDT) Message-ID: <4CD2CC30.6010605@gmail.com> Date: Thu, 04 Nov 2010 17:07:28 +0200 From: Vitalii Tymchyshyn User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.15) Gecko/20101027 Thunderbird/3.0.10 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Simple (hopefully) throughput question? References: <4CD1853F.2010800@noaa.gov> <4CD19785.9060301@enterprisedb.com> <4CD2C3BD.3030609@noaa.gov> In-Reply-To: <4CD2C3BD.3030609@noaa.gov> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201011/38 X-Sequence-Number: 41062 04.11.10 16:31, Nick Matheson написав(ла): > 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. ;) JDBC driver has some COPY support, but I don't remember details. You'd better ask in JDBC list. Best regards, Vitalii Tymchyshyn