projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 134d974) | patch
Add index on pg_publication_rel.prpubid
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Wed, 12 Jan 2022 19:23:42 +0000 (16:23 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Wed, 12 Jan 2022 19:24:26 +0000 (16:24 -0300)
commit025b920a3d45fed441a0a58fdcdf05b321b1eead
treee675ca15f0f6057083fc264ca3e30a7dd052379atree
parent134d9746364425e437a6d8eb1e2de0f3c59bfd2bcommit | 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
src/backend/catalog/pg_publication.c diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_publication_rel.h diff | blob | blame | history
This is the main PostgreSQL git repository.