Re: pg_stat_database view column xact_commit description should be more descriptive?

Поиск

Список

Период

Сортировка

От	Euler Taveira
Тема	Re: pg_stat_database view column xact_commit description should be more descriptive?
Дата	18 декабря 2022 г. 14:55:01
Msg-id	e225df4b-e79c-4a07-a609-b40bf24467c6@app.fastmail.com обсуждение
Ответ на	Re: pg_stat_database view column xact_commit description should be more descriptive? (Jaime Casanova <jcasanov@systemguards.com.ec>)
Список	pgsql-docs

Дерево обсуждения

On Fri, Dec 16, 2022, at 5:40 PM, Jaime Casanova wrote:

I want to hijack this thread to say that xact_commit seems to be also
counting COMMIT records received by logical replication.
Should we explain that in documentation?

Probably. I don't think adding something to pg_stat_database is appropriate.

IMO this concept should be explained in the logical replication chapter [1].

Logical replication uses transaction infrastructure to apply changes, hence,

statistics will take it into account.

What about physical replication? Are those also counted?

No. Physical replication does not use the transaction machinery to replicate

changes. It is in a lower layer and statistics don't apply at it.

[1] https://www.postgresql.org/docs/devel/logical-replication.html

Euler Taveira

EDB https://www.enterprisedb.com/

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: pg_stat_database view column xact_commit description should be more descriptive?