Add index on pg_publication_rel.prpubid

Enterprise / PostgreSQL - Alvaro Herrera [alvh.no-ip.org] - 12 January 2022 19:24 UTC

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

025b920a3d Add index on pg_publication_rel.prpubid
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(-)

Upstream: git.postgresql.org

  • Share