Re: Excessive LOG messages from replication slot sync worker - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Excessive LOG messages from replication slot sync worker
Date
Msg-id CAHGQGwHe4Qhxv24-d9no5_WM68b1OcjabCOJYtofXZy4-q6JKw@mail.gmail.com
Whole thread Raw
In response to Re: Excessive LOG messages from replication slot sync worker  (Japin Li <japinli@hotmail.com>)
Responses Re: Excessive LOG messages from replication slot sync worker
Re: Excessive LOG messages from replication slot sync worker
List pgsql-hackers
On Tue, Aug 12, 2025 at 6:25 PM Japin Li <japinli@hotmail.com> wrote:
> I believe that the format %X-%X also works with sscanf(). However, to maintain
> consistency, the format for sscanf() has been updated as well.

Yes.
Thanks for the patch!

Since we're changing the first "%X" in "%X-%X" to "%08X", the example
file names in the docs should be updated too. For example:

$ git grep "\.snap" | grep pglogicalinspect.sgml
doc/src/sgml/pglogicalinspect.sgml:name         | 0-40796E18.snap
doc/src/sgml/pglogicalinspect.sgml:postgres=# SELECT * FROM
pg_get_logical_snapshot_meta('0-40796E18.snap');
doc/src/sgml/pglogicalinspect.sgml:name     | 0-40796E18.snap
doc/src/sgml/pglogicalinspect.sgml:name         | 0-40796E18.snap
doc/src/sgml/pglogicalinspect.sgml:postgres=# SELECT * FROM
pg_get_logical_snapshot_info('0-40796E18.snap');
doc/src/sgml/pglogicalinspect.sgml:name                     | 0-40796E18.snap


I also noticed that the regression tests for pg_logicalinspect use file
names in the old format. This doesn't cause test failures, but should
we update them to match the new format?

...
contrib/pg_logicalinspect/sql/pg_logicalinspect.sql:SELECT
pg_get_logical_snapshot_info('0/40796E18.snap');
contrib/pg_logicalinspect/sql/pg_logicalinspect.sql:SELECT
pg_get_logical_snapshot_info('../snapshots/0-40796E18.snap');
contrib/pg_logicalinspect/sql/pg_logicalinspect.sql:SELECT
pg_get_logical_snapshot_meta('0-40796E18.foo.snap');
contrib/pg_logicalinspect/sql/pg_logicalinspect.sql:SELECT
pg_get_logical_snapshot_meta('0/40796E18.snap');
...

Regards,

--
Fujii Masao



pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Conflict detection for update_deleted in logical replication
Next
From: Etsuro Fujita
Date:
Subject: Re: Obsolete comments in ResultRelInfo struct