Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 926789FB248; Thu, 28 Sep 2006 19:24:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 67434-08; Thu, 28 Sep 2006 22:24:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from yass.opencloud.co.nz (yass.opencloud.co.nz [131.203.101.226]) by postgresql.org (Postfix) with ESMTP id F2CAA9FA17D; Thu, 28 Sep 2006 19:24:41 -0300 (ADT) Received: from 222-153-172-120.jetstream.xtra.co.nz ([222.153.172.120] helo=[10.1.1.3]) by yass.opencloud.co.nz with asmtp (TLS-1.0:DHE_RSA_AES_128_CBC_SHA:16) (Exim 4.34) id 1GT4J2-00055W-Q6; Fri, 29 Sep 2006 10:24:36 +1200 Message-ID: <451C4B9C.9060108@opencloud.com> Date: Thu, 28 Sep 2006 22:24:28 +0000 From: Oliver Jowett User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Sriram Dandapani CC: pgsql-jdbc@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [JDBC] number of transactions doubling References: <6992E470F12A444BB787B5C937B9D4DF060E5AD6@ca-mail1.cis.local> In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF060E5AD6@ca-mail1.cis.local> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/348 X-Sequence-Number: 23262 Sriram Dandapani wrote: > The target table has triggers that route data to appropriate tables. The > tables to which data is routed has check constraints that do further > inserts. (All of this happens in 1 jdbc transaction) > > I expect JDBC Batching to generate fewer transactions depending on > batch size. Have you turned autocommit off? -O