pg_stat_database view column xact_commit description should be more descriptive?
От | jian he |
---|---|
Тема | pg_stat_database view column xact_commit description should be more descriptive? |
Дата | |
Msg-id | CACJufxFUjNvGXWO7Rq8y5V8YyoMPGnf9Deeyw61Q=wVTqm-SiQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pg_stat_database view column xact_commit description should be more descriptive?
Re: pg_stat_database view column xact_commit description should be more descriptive? |
Список | pgsql-docs |
xact_commit
bigint
Number of transactions in this database that have been committed
BEGIN
initiates a transaction block, that is, all statements after aBEGIN
command will be executed in a single transaction until an explicitCOMMIT
orROLLBACK
is given. By default (withoutBEGIN
), PostgreSQL executes transactions in “autocommit” mode, that is, each statement is executed in its own transaction and a commit is implicitly performed at the end of the statement (if execution was successful, otherwise a rollback is done).
I guess the pg_stat_database view column xact_commit refers to 'non-autocommit' transactions?
If so, should we say something like "Number of autocommit transactions...."
I recommend David Deutsch's <<The Beginning of Infinity>>
Jian
В списке pgsql-docs по дате отправления: