Re: add checkpoint stats of snapshot and mapping files of pg_logical dir

Поиск
Список
Период
Сортировка
Искать
От
Nathan Bossart
Тема
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir
Дата
Msg-id
20220311200511.GA682814@nathanxps13
Ответ на
Список
Дерево обсуждения
add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Cary Huang <cary.huang@highgo.ca>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier <michael@paquier.xyz>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier <michael@paquier.xyz>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Andres Freund <andres@anarazel.de>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Andres Freund <andres@anarazel.de>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Andres Freund <andres@anarazel.de>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier <michael@paquier.xyz>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier <michael@paquier.xyz>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Hamid Akhtar <hamid.akhtar@percona.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Justin Pryzby <pryzby@telsasoft.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Michael Paquier <michael@paquier.xyz>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart <nathandbossart@gmail.com>
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
+    CheckpointStats.repl_map_cutoff_lsn = cutoff;

Could we set repl_map_cutoff_lsn closer to where it is calculated?  Right
now, it's set at the bottom of the function just before the directory is
freed.  Is there a strong reason to do it there?

+                        "logical rewrite mapping file(s) removed/synced=" UINT64_FORMAT ", size=%zu bytes, time=%ld.%03d s, cutoff LSN=%X/%X",

Can we split out the "removed" versus "synced" files?  Otherwise, I think
this is basically just telling us how many files are in the mappings
directory.

+    CheckpointStats.repl_snap_cutoff_lsn = cutoff;

I have the same note for this one as I have for repl_map_cutoff_lsn.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com


В списке pgsql-hackers по дате отправления
От: Nathan Bossart
Дата:
От: Tom Lane
Дата:
FAQ