Add Amcheck option for checking unique constraints in btree indexes

Edit

ID 3464

Title Add Amcheck option for checking unique constraints in btree indexes

Topic Monitoring & Control

Created 2021-12-20 15:42:28

Last modified 2023-10-27 21:22:28 (1 year ago)

Latest email 2024-07-26 20:53:38 (3 months, 3 weeks ago)

Status

2023-11: Committed

2023-09: Moved to next CF

2023-07: Moved to next CF

2023-03: Moved to next CF

2023-01: Moved to next CF

2022-11: Moved to next CF

2022-09: Moved to next CF

2022-07: Moved to next CF

2022-03: Moved to next CF

2022-01: Moved to next CF

Target version

Authors Anastasia Lubennikova (lubennikovaav), Maxim Orlov (m.orlov), Pavel Borisov (pborisov)

Reviewers Peter Geoghegan (pgeoghegan), Aleksander Alekseev (a.alekseev), Mark Dilger (mark.dilger)Become reviewer

Committer Alexander Korotkov (smagen)

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/3464
git checkout commitfest/cf/3464

Emails

[PATCH] Improve amcheck to also check UNIQUE constraint in btree index.: First at 2021-02-08 10:46:18 by Pavel Borisov <pashkin.elfe at gmail.com>
Latest at 2024-07-26 20:53:38 by Alexander Korotkov <aekorotkov at gmail.com>
Latest attachment (v4-0001-amcheck-Optimize-speed-of-checking-for-unique-con.patch) at 2024-07-26 12:10:32 from Alexander Korotkov <aekorotkov at gmail.com>
    Attachment (v4-0001-amcheck-Optimize-speed-of-checking-for-unique-con.patch) at 2024-07-26 12:10:32 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-a-WIP-corruption-checker.patch) at 2024-05-17 17:41:19 from Mark Dilger <mark.dilger at enterprisedb.com> (Patch: Yes)
    Attachment (XXXX-amcheck-Get-lowkey-only-for-internal-pages-of-btree-.patch) at 2024-05-13 11:55:11 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v3-0002-amcheck-Refactoring-the-storage-of-the-last-visib.patch) at 2024-05-13 01:42:20 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v2-0003-Amcheck-Don-t-load-rightpage-into-BtreeCheckState.patch) at 2024-05-10 00:11:41 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0004-Amcheck-Report-error-when-next-page-to-a-leaf-is-.patch) at 2024-04-25 12:59:54 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (0001-Teach-contrib-amcheck-to-check-the-unique-constr-v18.patch) at 2023-10-24 20:13:01 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-u.patch) at 2022-09-27 08:04:00 from Maxim Orlov <orlovmg at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-u.patch) at 2022-09-08 13:29:16 from Karina Litskevich <litskevichkarina at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-u.patch) at 2022-09-07 13:44:16 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v14-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-u.patch) at 2022-07-20 14:15:34 from Aleksander Alekseev <aleksander at timescale.com> (Patch: Yes)
    Attachment (v13-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-u.patch) at 2022-05-20 13:46:38 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-u.patch) at 2022-05-11 13:04:36 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-u.patch) at 2022-04-04 09:18:08 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-u.patch) at 2022-02-21 14:14:00 from Maxim Orlov <orlovmg at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-un.patch) at 2022-01-13 09:53:23 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-un.patch) at 2022-01-12 07:58:24 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-un.patch) at 2021-12-23 18:05:47 from Максим Орлов <orlovmg at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-un.patch) at 2021-12-22 08:01:24 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-un.patch) at 2021-12-20 15:37:35 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Make-amcheck-checking-UNIQUE-constraint-for-btree.patch) at 2021-03-02 14:08:43 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Make-amcheck-checking-UNIQUE-constraint-for-btree.patch) at 2021-02-09 18:57:34 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Make-amcheck-checking-UNIQUE-constraint-for-btree.patch) at 2021-02-09 18:43:50 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)
    Attachment (v1-0002-Ignore-unique-constraint-check-on-btree-insert.-P.patch) at 2021-02-08 10:46:18 from Pavel Borisov <pashkin.elfe at gmail.com> (Patch: Yes)

History

When	Who	What
2023-10-27 21:22:28	Alexander Korotkov (smagen)	Closed in commitfest 2023-11 with status: Committed
2023-10-27 21:22:28	Alexander Korotkov (smagen)	Changed committer to smagen
2023-10-01 19:52:52	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-01 08:14:53	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2023-07 with status: Moved to next CF
2023-04-09 03:21:04	Greg Stark (stark)	Changed targetversion to None
2023-04-09 02:54:51	Greg Stark (stark)	Closed in commitfest 2023-03 with status: Moved to next CF
2023-01-31 16:26:33	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-02 05:11:32	Michael Paquier (michael-kun)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-11-08 13:15:54	Ian Barwick (barwick)	Changed targetversion to 16
2022-10-12 06:47:01	Michael Paquier (michael-kun)	Closed in commitfest 2022-09 with status: Moved to next CF
2022-09-28 08:39:27	Aleksander Alekseev (aalekseev)	New status: Ready for Committer
2022-09-27 03:39:43	Hamid Akhtar (hamidakhtar)	New status: Waiting on Author
2022-08-01 17:15:20	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-24 09:43:57	Aleksander Alekseev (a.alekseev)	New status: Ready for Committer
2022-07-20 14:17:09	Aleksander Alekseev (a.alekseev)	Changed reviewers to Peter Geoghegan (pgeoghegan), Aleksander Alekseev (a.alekseev), Mark Dilger (mark.dilger)
2022-07-20 14:16:07	Aleksander Alekseev (a.alekseev)	Added a.alekseev as reviewer
2022-07-11 19:38:08	Pavel Borisov (pborisov)	Changed name to Add Amcheck option for checking unique constraints in btree indexes
2022-07-11 19:36:45	Pavel Borisov (pborisov)	Changed name to Add amcheck option for checking unique constraints in btree indexes
2022-04-08 14:08:51	Greg Stark (stark)	Closed in commitfest 2022-03 with status: Moved to next CF
2022-04-04 09:18:51	Pavel Borisov (pborisov)	New status: Needs review
2022-04-03 00:03:19	Greg Stark (stark)	New status: Waiting on Author
2022-02-02 16:29:49	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-12 07:59:57	Pavel Borisov (pborisov)	New status: Needs review
2022-01-12 06:51:55	Julien Rouhaud (rjuju)	New status: Waiting on Author
2021-12-22 08:02:37	Pavel Borisov (pborisov)	New status: Needs review
2021-12-21 19:42:41	Mark Dilger (mark.dilger)	New status: Waiting on Author
2021-12-20 15:44:34	Pavel Borisov (pborisov)	Changed reviewers to Mark Dilger (mark.dilger)
2021-12-20 15:44:34	Pavel Borisov (pborisov)	Changed authors to Anastasia Lubennikova (lubennikovaav), Maxim Orlov (m.orlov), Pavel Borisov (pborisov)
2021-12-20 15:44:34	Pavel Borisov (pborisov)	Changed targetversion to 15
2021-12-20 15:42:28	Pavel Borisov (pborisov)	Attached mail thread CALT9ZEHRn5xAM5boga0qnrCmPV52bScEK2QnQ1HmUZDD301JEg@mail.gmail.com
2021-12-20 15:42:28	Pavel Borisov (pborisov)	Created patch record

Edit