increase of xact_commit vs txid_current - Mailing list pgsql-general

From reg_pg_stefanz@perfexpert.ch
Subject increase of xact_commit vs txid_current
Date
Msg-id 9c38fdbe-0972-07e5-6cfd-0367b1bfe5b9@perfhope.info
Whole thread Raw
Responses Re: increase of xact_commit vs txid_current  (Julien Rouhaud <rjuju123@gmail.com>)
List 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




pgsql-general by date:

Previous
From: Eudald Valcàrcel Lacasa
Date:
Subject: pg_dump negation regex
Next
From: Christian Ramseyer
Date:
Subject: Re: Lock Postgres account after X number of failed logins?