Add index on pg_publication_rel.prpubid This should have been added for the benefit of GetPublicationRelations; let's add it now.
I couldn't measure a performance difference in the TAP tests, but that may be because the tests use very few publications. Discussion: https://postgr.es/m/202201120041.p24wvsfcsope@alvherre.pgsql Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/025b920a3d45fed441a0a58fdcdf05b321b1eead Modified Files -------------- src/backend/catalog/pg_publication.c | 2 +- src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_publication_rel.h | 1 + 3 files changed, 3 insertions(+), 2 deletions(-)
