Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index.

From:	Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>
To:	Greg Stark <stark(at)mit(dot)edu>
Cc:	Maxim Orlov <orlovmg(at)gmail(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, David Steele <david(at)pgmasters(dot)net>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>, Maxim Orlov <m(dot)orlov(at)postgrespro(dot)ru>, lubennikovaav(at)gmail(dot)com
Subject:	Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index.
Date:	2022-05-20 13:46:38
Message-ID:	CALT9ZEG1YAfPBH-ZMnK-cxu0SDdrV_w0QEBs9BLHfWvddpOHFA@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2021-02-08 10:46:18 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎  2021-02-08 19:31:13 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>  2021-02-08 21:46:50 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>   2021-02-09 18:43:50 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎    2021-02-09 18:57:34 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎    2021-02-09 19:41:16 from Zhihong Yu <zyu(at)yugabyte(dot)com>    2021-03-01 19:21:59 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>     2021-03-01 20:05:57 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>      2021-03-01 20:20:31 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>       2021-03-01 20:23:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2021-03-01 20:23:23 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>      2021-03-01 21:05:03 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>       2021-03-02 14:08:43 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎        2021-03-15 15:11:29 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>         2021-04-08 14:36:36 from David Steele <david(at)pgmasters(dot)net>          2021-12-20 15:37:35 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎           2021-12-20 18:02:18 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>            2021-12-22 08:01:24 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎             2021-12-23 16:31:29 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>              2021-12-23 18:05:47 from Максим Орлов <orlovmg(at)gmail(dot)com> 📎               2022-01-12 06:47:34 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                2022-01-12 07:58:24 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                 2022-01-13 09:53:23 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                  2022-02-21 14:14:00 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                   2022-04-03 00:02:07 from Greg Stark <stark(at)mit(dot)edu>                    2022-04-04 09:18:08 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                     2022-05-11 13:04:36 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                      2022-05-20 13:46:38 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                       2022-07-20 14:15:34 from Aleksander Alekseev <aleksander(at)timescale(dot)com> 📎                        2022-09-07 13:44:16 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                         2022-09-08 13:29:16 from Karina Litskevich <litskevichkarina(at)gmail(dot)com> 📎                       2022-09-22 15:13:28 from Andres Freund <andres(at)anarazel(dot)de>                        2022-09-27 08:04:00 from Maxim Orlov <orlovmg(at)gmail(dot)com> 📎                         2022-09-28 08:36:40 from Maxim Orlov <orlovmg(at)gmail(dot)com>                          2022-09-28 08:43:57 from Aleksander Alekseev <aleksander(at)timescale(dot)com>                           2023-10-24 20:13:01 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                            2023-10-30 07:29:04 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                             2024-03-25 02:03:23 from Noah Misch <noah(at)leadboat(dot)com>                              2024-03-25 16:03:10 from Peter Geoghegan <pg(at)bowt(dot)ie>                               2024-03-25 18:24:43 from Noah Misch <noah(at)leadboat(dot)com>                                2024-03-29 18:17:08 from Peter Geoghegan <pg(at)bowt(dot)ie>                                 2024-03-29 23:47:52 from Noah Misch <noah(at)leadboat(dot)com>                                 2024-04-17 15:41:10 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                  2024-04-24 09:57:24 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                            2024-04-17 06:38:48 from Peter Eisentraut <peter(at)eisentraut(dot)org>                             2024-04-24 09:58:11 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                              2024-04-25 12:59:54 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                               2024-04-25 13:44:19 from Karina Litskevich <litskevichkarina(at)gmail(dot)com>                                2024-04-25 13:54:39 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                               2024-05-01 02:24:12 from Noah Misch <noah(at)leadboat(dot)com>                                2024-05-01 02:26:13 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                 2024-05-10 00:11:41 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                  2024-05-10 00:42:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                   2024-05-10 07:34:25 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                   2024-05-10 08:39:18 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                    2024-05-10 12:10:04 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                     2024-05-10 17:35:13 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                      2024-05-10 18:42:01 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                       2024-05-10 18:43:46 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                       2024-05-10 19:27:11 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                      2024-05-10 19:05:01 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                       2024-05-11 01:12:57 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                        2024-05-11 01:38:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                        2024-05-12 21:23:42 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                         2024-05-13 01:42:20 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                          2024-05-13 11:55:11 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                                           2024-05-13 12:19:54 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                            2024-05-13 12:20:25 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                          2024-05-17 10:11:32 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                           2024-05-17 11:09:04 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                           2024-05-17 17:41:19 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> 📎                                            2024-05-17 18:51:38 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                             2024-05-17 19:10:10 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                              2024-05-17 19:42:26 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                               2024-05-17 20:00:55 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                2024-05-17 20:10:46 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                 2024-05-17 20:13:20 from Peter Geoghegan <pg(at)bowt(dot)ie>                                              2024-05-17 19:42:42 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                               2024-05-17 20:08:10 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                                2024-05-17 21:08:03 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                           2024-07-26 12:10:32 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                            2024-07-26 14:38:03 from Robert Haas <robertmhaas(at)gmail(dot)com>                                             2024-07-26 20:53:38 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>     2021-03-03 02:54:59 from Peter Geoghegan <pg(at)bowt(dot)ie>  2021-03-03 03:10:32 from Peter Geoghegan <pg(at)bowt(dot)ie>   2021-03-03 08:08:00 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v13-0001-Add-option-for-amcheck-and-pg_amcheck-to-check-u.patch	application/x-patch	42.5 KB

In response to

• Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index. at 2022-05-11 13:04:36 from Pavel Borisov

Responses

• Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index. at 2022-07-20 14:15:34 from Aleksander Alekseev
• Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index. at 2022-09-22 15:13:28 from Andres Freund

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Maxim Orlov	2022-05-20 14:38:03	Re: Add 64-bit XIDs into PostgreSQL 15
Previous Message	Shinoda, Noriyoshi (PN Japan FSIP)	2022-05-20 12:46:03	PG15 beta1 fix pg_stat_statements view document