| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Add index on pg_publication_rel.prpubid |
| Date: | 2022-01-12 19:24:57 |
| Message-ID: | E1n7jEv-0003dI-Qm@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2022-01-12 21:48:28 | pgsql: Consider fractional paths in generate_orderedappend_paths |
| Previous Message | Tom Lane | 2022-01-12 19:23:21 | pgsql: Include permissive/enforcing state in sepgsql log messages. |