Maria L. Wilson wrote: > yes - how do i get rid of these?? > > backend> select * from pg_prepared_xacts; > 2009-04-22 07:43:27.421 EDT [11767] [] WARNING: database "ange" must > be vacuumed within 976080 transactions > 2009-04-22 07:43:27.421 EDT [11767] [] HINT: To avoid a database > shutdown, execute a full-database VACUUM in "ange". > 1: transaction (typeid = 28, len = 4, typmod = -1, byval = t) > 2: gid (typeid = 25, len = -1, typmod = -1, byval = f) > 3: prepared (typeid = 1184, len = 8, typmod = -1, byval = f) > 4: owner (typeid = 19, len = 64, typmod = -1, byval = f) > 5: database (typeid = 19, len = 64, typmod = -1, byval = f) > ---- > 1: transaction = "339484494" (typeid = 28, len = 4, typmod = -1, > byval = t) > 2: gid = "257_cGMwNzQvNjAyNA==_MQ==" (typeid = 25, len = -1, ROLLBACK PREPARED '257_cGMwNzQvNjAyNA==_MQ=='; and so on. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
