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
Topic Replication & Recovery
Created 2022-10-03 15:53:58
Last modified 2022-10-20 04:28:19 (2 years, 1 month ago)
Latest email 2023-03-18 09:49:43 (1 year, 8 months ago)
Status
2022-11: Returned with feedback
Target version
Authors Onder Kalaci (onderkalaci)
Reviewers Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3926
git checkout commitfest/cf/3926
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