| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Sriram Dandapani <sdandapani(at)counterpane(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [JDBC] number of transactions doubling |
| Date: | 2006-09-28 22:24:28 |
| Message-ID: | 451C4B9C.9060108@opencloud.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sriram Dandapani | 2006-09-28 22:52:15 | Re: [JDBC] number of transactions doubling |
| Previous Message | Paul B. Anderson | 2006-09-28 22:13:04 | Addendum on stored procedure array limits |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sriram Dandapani | 2006-09-28 22:52:15 | Re: [JDBC] number of transactions doubling |
| Previous Message | Sriram Dandapani | 2006-09-28 21:51:24 | number of transactions doubling |