FYI..I use the postgres8.1.404 jdbc driver -----Original Message----- From: Oliver Jowett [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 3:24 PM To: Sriram Dandapani Cc: pgsql-jdbc@postgresql.org; pgsql-admin@postgresql.org Subject: Re: [JDBC] number of transactions doubling
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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
