From: | "Euler Taveira" <euler(at)eulerto(dot)com> |
---|---|
To: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>, "jian he" <jian(dot)universality(at)gmail(dot)com> |
Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_stat_database view column xact_commit description should be more descriptive? |
Date: | 2022-12-18 14:55:01 |
Message-ID: | e225df4b-e79c-4a07-a609-b40bf24467c6@app.fastmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | PG Doc comments form | 2022-12-22 02:02:05 | tar command example for backup file |
Previous Message | Jaime Casanova | 2022-12-16 20:40:30 | Re: pg_stat_database view column xact_commit description should be more descriptive? |