Postgres Pro
Downloads
Home   >   mailing lists

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

does autovacuum in postgres-8.1.2 use prepared transactions ??

From
"tamanna madaan"
Date:

Hi All

 

I am using postgres-8.1.2.

 

Can anyone please let me know if autovacuum in postgres-8.1.2 uses prepared transactions.

 

 

Thanks a lot in advance

 

 

Regards

Tamanna

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

From
Tom Lane
Date:
"tamanna madaan" <tamanna.madan@globallogic.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

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

From
"tamanna madaan"
Date:
Thanks Tom ...

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

"tamanna madaan" <tamanna.madan@globallogic.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