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/include | |
| 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/include')
| -rw-r--r-- | src/include/catalog/catversion.h | 2 | ||||
| -rw-r--r-- | src/include/catalog/pg_publication_rel.h | 1 |
2 files changed, 2 insertions, 1 deletions
diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h index 23cc4b48aac..fc904bcb9be 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 0ff37162258..117a1d67e56 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 */ |