Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher

Edit
Comment/Review
Change Status
Title Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
Topic Replication & Recovery
Created 2022-07-12 13:55:01
Last modified 2023-03-18 09:47:16 (6 months, 1 week ago)
Latest email 2023-03-18 09:49:43 (6 months, 1 week ago)
Status
2023-03: Committed
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
Target version 16
Authors Onder Kalaci (onderkalaci)
Reviewers vigneshwaran C (vignesh.postgres)Become reviewer
Committer Amit Kapila (amitkapila)
Links
Emails
[PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
First at 2022-07-12 13:36:45 by Önder Kalacı <onderkalaci at gmail.com>
Latest at 2023-03-18 09:49:43 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (v51_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-14 09:48:38 from Önder Kalacı <onderkalaci at gmail.com>
    Attachment (v51_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-14 09:48:38 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v50_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-14 09:06:31 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v49-0001-Allow-the-use-of-indexes-other-than-PK-and-REPLI.patch) at 2023-03-14 07:18:08 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v48-0001-Allow-the-use-of-indexes-other-than-PK-and-REPLI.patch) at 2023-03-14 06:50:14 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v47_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-13 14:16:23 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v46_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-13 12:43:54 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v45_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-13 11:48:13 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v45_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-13 10:51:00 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (0002-WIP-Optimize-for-non-pkey-non-RI-unique-indexes.patch.txt) at 2023-03-13 09:42:47 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v44_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-12 15:07:21 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v43_0002_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-10 14:28:33 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v42_0001_Skip-dropped_columns_for_tuples_equal.patch) at 2023-03-10 11:46:43 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v41_0002_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-10 10:58:25 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v40_0001_Skip-dropped_columns_for_tuples_equal.patch) at 2023-03-10 09:54:48 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v39_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-09 12:18:28 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (wip_optimize_for_non_pkey_non_ri_unique_index.patch) at 2023-03-09 12:17:32 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v38_0002_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-09 09:56:00 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v37_0002_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-08 16:16:22 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v36_0002_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-08 11:11:46 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v35_0002_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-07 13:47:07 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v34_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-07 10:59:18 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (use_index_sub_amit_1.patch) at 2023-03-07 06:57:58 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v33_0002_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-06 11:18:39 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v32_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-06 09:08:20 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v31_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-03 14:15:49 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v30_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-03 13:10:33 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v29_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-03 09:32:39 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v28_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-03 07:39:55 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v27_0002_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-02 15:22:44 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v26_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-03-02 09:30:20 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (perf_index_scan.svg) at 2023-03-01 13:21:52 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v25_0001_optionally_disable_index.patch) at 2023-02-22 14:24:03 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v24_0001_optionally_disable_index.patch) at 2023-02-21 14:25:10 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v23_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2023-02-02 08:33:36 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v22_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-12-12 13:28:23 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v21_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-11-11 16:16:36 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v20_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-10-21 12:14:09 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v19_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-10-18 16:04:33 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v18_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-10-14 16:04:02 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v17_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-10-12 18:44:06 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v16_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-10-11 12:44:06 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v15_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-10-07 11:54:00 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v14_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-09-29 17:08:52 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v13_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-09-22 16:13:54 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v12_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-09-20 10:29:34 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v11_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-09-19 15:32:03 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v10_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-09-14 12:04:00 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v10_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-09-01 06:23:11 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v9_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-08-25 09:09:15 from Önder Kalacı <onderkalaci at gmail.com> (Patch: No)
    Attachment (v8_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-08-23 16:24:42 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v7_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-08-20 11:02:03 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v6_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-08-12 15:11:55 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v5_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-08-08 15:58:52 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v4_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-08-01 16:21:48 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v3_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-07-29 14:59:20 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (v2_0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-07-22 16:15:16 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)
    Attachment (0001_use_index_on_subs_when_pub_rep_ident_full.patch) at 2022-07-12 13:36:45 from Önder Kalacı <onderkalaci at gmail.com> (Patch: Yes)

Annotations

When Who Mail Annotation
2022-10-20 04:28:02 Justin Pryzby (justinpryzby) From "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
at 2022-10-20 02:37:43		 This is a duplicate of: https://commitfest.postgresql.org/40/3765/
History
When Who What
2023-03-18 09:47:16 Amit Kapila (amitkapila) Closed in commitfest 2023-03 with status: Committed
2023-03-18 09:47:16 Amit Kapila (amitkapila) Changed committer to amitkapila
2023-03-08 03:49:28 vigneshwaran C (vignesh.postgres) Added vignesh.postgres as reviewer
2023-01-31 16:20:42 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-07 17:58:52 Tom Lane (tgl) New status: Needs review
2022-12-08 14:06:31 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-07 18:29:20 Andres Freund (andresfreund) New status: Waiting on Author
2022-10-20 04:28:02 Justin Pryzby (justinpryzby) Added annotation "This is a duplicate of: https://commitfest.postgresql.org/40/3765/" to OSZPR01MB63109FF52120649EECACC7AEFD2A9@OSZPR01MB6310.jpnprd01.prod.outlook.com
2022-10-12 07:03:56 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-07-12 13:56:30 Onder Kalacı (onderk) Changed authors to Onder Kalaci (onderkalaci)
2022-07-12 13:56:30 Onder Kalacı (onderk) Changed targetversion to 16
2022-07-12 13:55:02 Onder Kalacı (onderk) Attached mail thread CACawEhVLqmAAyPXdHEPv1ssU2c=dqOniiGz7G73HfyS7+nGV4w@mail.gmail.com
2022-07-12 13:55:01 Onder Kalacı (onderk) Created patch record
Edit
Comment/Review
Change Status