"tamanna madaan" <tamanna.madan@xxxxxxxxxxxxxxx> writes: > Can anyone please let me know if autovacuum in postgres-8.1.2 uses > prepared transactions. Nope, it does not. Any prepared transactions you see hanging around were created by some external client. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general