From 025b920a3d45fed441a0a58fdcdf05b321b1eead Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Wed, 12 Jan 2022 16:23:42 -0300 Subject: [PATCH] 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 --- 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(-) diff --git a/src/backend/catalog/pg_publication.c b/src/backend/catalog/pg_publication.c index 2992a2e0c6..cf0700f8ba 100644 --- a/src/backend/catalog/pg_publication.c +++ b/src/backend/catalog/pg_publication.c @@ -494,7 +494,7 @@ GetPublicationRelations(Oid pubid, PublicationPartOpt pub_partopt) BTEqualStrategyNumber, F_OIDEQ, ObjectIdGetDatum(pubid)); - scan = systable_beginscan(pubrelsrel, PublicationRelPrrelidPrpubidIndexId, + scan = systable_beginscan(pubrelsrel, PublicationRelPrpubidIndexId, true, NULL, 1, &scankey); result = NIL; diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h index 23cc4b48aa..fc904bcb9b 100644 --- a/src/include/catalog/catversion.h +++ b/src/include/catalog/catversion.h @@ -53,6 +53,6 @@ */ /* yyyymmddN */ -#define CATALOG_VERSION_NO 202112131 +#define CATALOG_VERSION_NO 202201121 #endif diff --git a/src/include/catalog/pg_publication_rel.h b/src/include/catalog/pg_publication_rel.h index 0ff3716225..117a1d67e5 100644 --- a/src/include/catalog/pg_publication_rel.h +++ b/src/include/catalog/pg_publication_rel.h @@ -42,5 +42,6 @@ typedef FormData_pg_publication_rel *Form_pg_publication_rel; DECLARE_UNIQUE_INDEX_PKEY(pg_publication_rel_oid_index, 6112, PublicationRelObjectIndexId, on pg_publication_rel using btree(oid oid_ops)); DECLARE_UNIQUE_INDEX(pg_publication_rel_prrelid_prpubid_index, 6113, PublicationRelPrrelidPrpubidIndexId, on pg_publication_rel using btree(prrelid oid_ops, prpubid oid_ops)); +DECLARE_INDEX(pg_publication_rel_prpubid_index, 6116, PublicationRelPrpubidIndexId, on pg_publication_rel using btree(prpubid oid_ops)); #endif /* PG_PUBLICATION_REL_H */ -- 2.39.5