On Wed, 2009-04-22 at 13:10 -0400, Maria L. Wilson wrote: > wow - I am finally back in business!! > Question - is there any maintenance type item that we could to to check > for uncommitted transactions on a regular basis - outside of the > pg_prepared_xacts table? > How about from a developers position - most of our code accessing > the databases is jboss/java/jdbc. What could have happened from the > code side that caused these uncommitted transactions? The use of XA/two phase commit transactions that assume rollback on disconnect. Joshua D. Drake -- PostgreSQL - XMPP: jdrake@xxxxxxxxxxxxxxxxxxxxx Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
