pg_stat_activity xact_start and autovacuum

Поиск
Список
Период
Сортировка
От Dawid Kuroczko
Тема pg_stat_activity xact_start and autovacuum
Дата
Msg-id 758d5e7f0802110404g212acf73j2be310093f8dae1b@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_stat_activity xact_start and autovacuum
Список pgsql-general
Hello.

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.

   Regards,
      Dawid

В списке pgsql-general по дате отправления:

Предыдущее
От: paul rivers
Дата:
Сообщение: Re: using SSL in psql
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Mechanics of Select