pgsql: Add index on pg_publication_rel.prpubid - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Add index on pg_publication_rel.prpubid
Date
Msg-id E1n7jEv-0003dI-Qm@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Include permissive/enforcing state in sepgsql log messages.
Next
From: Tomas Vondra
Date:
Subject: pgsql: Consider fractional paths in generate_orderedappend_paths