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:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 2:39 PM To: Sriram Dandapani Cc: Jim Nasby; Heikki Linnakangas; pgsql-jdbc@postgresql.org; pgsql-admin@postgresql.org Subject: Re: [JDBC] [ADMIN] number of transactions doubling "Sriram Dandapani" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
