Re: pg_stat_activity xact_start and autovacuum

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Dawid Kuroczko <qnex42(at)gmail(dot)com>
Cc: General postgres mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_stat_activity xact_start and autovacuum
Date: 2008-02-11 13:27:40
Message-ID: 20080211132740.GA6056@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2008-02-11 13:46:00 Re: end of life for pg versions...
Previous Message Ivan Sergio Borgonovo 2008-02-11 13:04:32 end of life for pg versions...