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

Edit
ID 3926
Title Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Replication & Recovery
Tags
Created 2022-10-03 15:53:58
Last modified 2022-10-20 04:28:19 (3 years ago)
Latest email 2023-03-18 09:49:43 (2 years ago)
Status
2022-11 (2022-11-01 – 2022-11-30): Returned with feedback
Target version
Authors Onder Kalaci (onderkalaci)
Reviewers Become reviewer
Committer
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
2022-10-20 04:28:19 Justin Pryzby (justinpryzby) Closed in commitfest 2022-11 with status: Returned with feedback
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-03 15:54:17 Onder Kalacı (onderk) Changed authors to Onder Kalaci (onderkalaci)
2022-10-03 15:53:59 Onder Kalacı (onderk) Attached mail thread CACawEhVLqmAAyPXdHEPv1ssU2c=dqOniiGz7G73HfyS7+nGV4w@mail.gmail.com
2022-10-03 15:53:58 Onder Kalacı (onderk) Created patch record
Edit