abdelhak benmohamed wrote:
> Hellow
> I like to track the number of committed transaction for my database
> So I use the following command
> Select pg_stat_get_db_xact_commit(16384)
>
> (16384 is the oid of my database)
>
> It gives me 35
>
> But if I execute the same command another time, it gives me more than 35.
>
> Between the first select and the second select I don’t execute transaction on
> my database
>
> Please, can any one help me to understanding the cause of the change?
Maybe autovacuum running underneath committed some transactions. (Also,
each time you call the function it starts and commit a new transaction).
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general