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

Edit

3765

Title

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

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