Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_stat_activity xact_start and autovacuum - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: pg_stat_activity xact_start and autovacuum
Date
Msg-id 20080211132740.GA6056@alvh.no-ip.org
Whole thread Raw
In response to pg_stat_activity xact_start and autovacuum  ("Dawid Kuroczko" <qnex42@gmail.com>)
Responses Re: pg_stat_activity xact_start and autovacuum
List pgsql-general
Tree view 
Dawid Kuroczko escribió:

> I'm using 8.3.0 and I see that autovacuum processes in
> pg_stat_activity have xact_start.
>
> As far as I know, since at least 8.2.x the VACUUM does not start a new
> transaction.
> If that statement is correct, the xact_start column in
> pg_stat_activity should be NULL...
> Why does it matter?  Monitoring.  It's good to know the age of oldest
> running transaction, and autovacuuming is well, adding noise.

Autovacuum certainly uses transactions ...  ??

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: end of life for pg versions...
Next
From: "Christopher Browne"
Date:
Subject: Re: end of life for pg versions...