| 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: | Whole Thread | Raw Message | 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? |