Horton

Add index on pg_publication_rel.prpubid

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: 025b920a3d45fed441a0a58fdcdf05b321b1eead
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2022-01-12T19:24:26Z
Releases: 15.0 
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

Files

PathChange+/−
src/backend/catalog/pg_publication.c modified +1 −1
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_publication_rel.h modified +1 −0

Discussion