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

Edit
ID 3765
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-07-12 13:55:01
Last modified 2023-03-18 09:47:16 (2 years ago)
Latest email 2023-03-18 09:49:43 (2 years ago)
Status
2023-03 (2023-03-01 – 2023-04-08): Committed
2023-01 (2023-01-01 – 2023-01-31): Moved to different CF
2022-11 (2022-11-01 – 2022-11-30): Moved to different CF
2022-09 (2022-09-01 – 2022-09-30): Moved to different 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