CREATE PUBLICATION perfomance

Question

I want to create publications in several databases like this:

CREATE PUBLICATION dbz_publication FOR ALL TABLES;

My Debezium should not create them automatically, because the service that uses Debezium does not have superuser permissions, and it won't always use them.

How does having a publication affect database performance?

I tried to find information in the PostgreSQL documentation, but couldn't find it.

Answer 1

A publication that has no subscribers has no performance impact. It is just a definition sitting in the metadata for use with logical replication.