Re: does autovacuum in postgres-8.1.2 use prepared transactions ??

From: "tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>, "Gaurav Katiyar" <gaurav(dot)katiyar(at)globallogic(dot)com>
Subject: Re: does autovacuum in postgres-8.1.2 use prepared transactions ??
Date: 2010-01-12 04:50:36
Message-ID: 68666423656E1444A011106C4E085F4DB3B09B@ex3-del1.synapse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Tom ...

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, January 12, 2010 1:35 AM
To: tamanna madaan
Cc: pgsql-general(at)postgresql(dot)org; Gaurav Katiyar
Subject: Re: [GENERAL] does autovacuum in postgres-8.1.2 use prepared
transactions ??

"tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2010-01-12 05:06:01 location for pg_default tablespace
Previous Message Francisco Reyes 2010-01-12 04:40:47 Re: Using a lock to avoid: could not open relation with OID