NotificationsYou must be signed in to change notification settings
Fork4.9k
Star17.7k

Commit025b920

committed

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 thatmay be because the tests use very few publications.Discussion:https://postgr.es/m/202201120041.p24wvsfcsope@alvherre.pgsql

1 parent134d974 commit025b920Copy full SHA for 025b920

File tree

3 files changed

-2

lines changed

src
- backend/catalog
  - pg_publication.c
- include/catalog
  - catversion.h
  - pg_publication_rel.h

3 files changed

-2

lines changed

`‎src/backend/catalog/pg_publication.c`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -494,7 +494,7 @@ GetPublicationRelations(Oid pubid, PublicationPartOpt pub_partopt)`
`494`	`494`	`BTEqualStrategyNumber,F_OIDEQ,`
`495`	`495`	`ObjectIdGetDatum(pubid));`
`496`	`496`
`497`		`-scan=systable_beginscan(pubrelsrel,PublicationRelPrrelidPrpubidIndexId,`
	`497`	`+scan=systable_beginscan(pubrelsrel,PublicationRelPrpubidIndexId,`
`498`	`498`	`true,NULL,1,&scankey);`
`499`	`499`
`500`	`500`	`result=NIL;`

`‎src/include/catalog/catversion.h`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -53,6 +53,6 @@`
`53`	`53`	`*/`
`54`	`54`
`55`	`55`	`/yyyymmddN /`
`56`		`-#defineCATALOG_VERSION_NO202112131`
	`56`	`+#defineCATALOG_VERSION_NO202201121`
`57`	`57`
`58`	`58`	`#endif`

`‎src/include/catalog/pg_publication_rel.h`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -42,5 +42,6 @@ typedef FormData_pg_publication_rel *Form_pg_publication_rel;`
`42`	`42`
`43`	`43`	`DECLARE_UNIQUE_INDEX_PKEY(pg_publication_rel_oid_index,6112,PublicationRelObjectIndexId,onpg_publication_relusingbtree(oidoid_ops));`
`44`	`44`	`DECLARE_UNIQUE_INDEX(pg_publication_rel_prrelid_prpubid_index,6113,PublicationRelPrrelidPrpubidIndexId,onpg_publication_relusingbtree(prrelidoid_ops,prpubidoid_ops));`
	`45`	`+DECLARE_INDEX(pg_publication_rel_prpubid_index,6116,PublicationRelPrpubidIndexId,onpg_publication_relusingbtree(prpubidoid_ops));`
`45`	`46`
`46`	`47`	`#endif/* PG_PUBLICATION_REL_H */`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit025b920

File tree

3 files changed

3 files changed

`‎src/backend/catalog/pg_publication.c`

`‎src/include/catalog/catversion.h`

`‎src/include/catalog/pg_publication_rel.h`

0 commit comments