diff options
| author | Alvaro Herrera | 2022-01-12 19:23:42 +0000 |
|---|---|---|
| committer | Alvaro Herrera | 2022-01-12 19:24:26 +0000 |
| commit | 025b920a3d45fed441a0a58fdcdf05b321b1eead (patch) | |
| tree | e675ca15f0f6057083fc264ca3e30a7dd052379a /src/backend | |
| parent | 134d9746364425e437a6d8eb1e2de0f3c59bfd2b (diff) | |
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
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/catalog/pg_publication.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backend/catalog/pg_publication.c b/src/backend/catalog/pg_publication.c index 2992a2e0c63..cf0700f8ba0 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; |