increase of xact_commit vs txid_current

From: reg_pg_stefanz(at)perfexpert(dot)ch
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: increase of xact_commit vs txid_current
Date: 2020-05-07 17:01:12
Message-ID: 9c38fdbe-0972-07e5-6cfd-0367b1bfe5b9@perfhope.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am confused, the documentation says for pg_stat_database
   xact_commit      Number of transactions in this database that have
been committed
and somewhere else
    txid_current()    get current transaction ID, assigning a new one
if the current transaction does not have one

I would have naively expected txid_current() be more or less in line
with xact_commit,  or  increasing faster as txid_current() should be
global but xact_commit is per database.

However xact_commit seems to increases faster than txid_current(),  what
am I missing? Are there commits that do not increase the xid number?

Thanks
Stefan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Ramseyer 2020-05-07 17:01:47 Re: Lock Postgres account after X number of failed logins?
Previous Message Eudald Valcàrcel Lacasa 2020-05-07 16:53:47 pg_dump negation regex