Thanks for the clarification(I was puzzled on why the xid count was really high) That probably explains why my xid counter rapidly increases. -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Friday, September 29, 2006 2:39 PM To: Sriram Dandapani Cc: Jim Nasby; Heikki Linnakangas; pgsql-jdbc@xxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [JDBC] [ADMIN] number of transactions doubling "Sriram Dandapani" <sdandapani@xxxxxxxxxxxxxxx> writes: > Does the presence of an exception clause generate subtransactions > regardless of whether exceptions occurred? If so, do subtransactions > count towards the transaction id wraparound limit counter? Yes, and yes. regards, tom lane