Thanks Tom ... -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Tuesday, January 12, 2010 1:35 AM To: tamanna madaan Cc: pgsql-general@xxxxxxxxxxxxxx; Gaurav Katiyar Subject: Re: does autovacuum in postgres-8.1.2 use prepared transactions ?? "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