Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY

From:	Michael Paquier <michael(at)paquier(dot)xyz>
To:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc:	Andres Freund <andres(at)anarazel(dot)de>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, Петър Славов <pet(dot)slavov(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject:	Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Date:	2022-05-31 04:25:17
Message-ID:	YpWYrZakuN49wJQU@paquier.xyz
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-05-18 10:42:13 from PG Bug reporting form <noreply(at)postgresql(dot)org>  2022-05-19 04:22:44 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>   2022-05-19 04:32:46 from Michael Paquier <michael(at)paquier(dot)xyz>    2022-05-19 05:24:27 from Петър Славов <pet(dot)slavov(at)gmail(dot)com>     2022-05-19 08:02:32 from Michael Paquier <michael(at)paquier(dot)xyz>      2022-05-19 12:03:56 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>       2022-05-23 05:40:16 from Michael Paquier <michael(at)paquier(dot)xyz> 📎        2022-05-23 08:07:44 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>         2022-05-23 09:02:40 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>          2022-05-23 18:13:12 from Peter Geoghegan <pg(at)bowt(dot)ie>         2022-05-24 01:08:29 from Michael Paquier <michael(at)paquier(dot)xyz>        2022-05-23 10:49:02 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru> 📎         2022-05-23 13:06:10 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru> 📎          2022-05-23 18:18:10 from Peter Geoghegan <pg(at)bowt(dot)ie>         2022-05-24 01:20:02 from Michael Paquier <michael(at)paquier(dot)xyz>          2022-05-24 02:19:50 from Peter Geoghegan <pg(at)bowt(dot)ie>           2022-05-24 09:02:12 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>            2022-05-24 10:08:33 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>            2022-05-24 16:37:02 from Andres Freund <andres(at)anarazel(dot)de>             2022-05-24 17:38:14 from Peter Geoghegan <pg(at)bowt(dot)ie>              2022-05-24 18:46:54 from Andres Freund <andres(at)anarazel(dot)de>             2022-05-24 18:15:42 from Andres Freund <andres(at)anarazel(dot)de>              2022-05-24 18:37:05 from Andres Freund <andres(at)anarazel(dot)de>              2022-05-24 18:38:07 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>               2022-05-24 19:01:33 from Andres Freund <andres(at)anarazel(dot)de>                2022-05-24 21:11:12 from Greg Stark <stark(at)mit(dot)edu>                 2022-05-24 22:24:33 from Andres Freund <andres(at)anarazel(dot)de>                  2022-05-25 00:59:27 from Michael Paquier <michael(at)paquier(dot)xyz>                2022-05-25 04:00:47 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>                 2022-05-25 04:20:49 from Andres Freund <andres(at)anarazel(dot)de>                2022-05-25 11:44:54 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                 2022-05-25 12:39:14 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2022-05-25 16:43:22 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                   2022-05-25 17:08:21 from Andres Freund <andres(at)anarazel(dot)de>                   2022-05-25 17:17:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2022-05-25 17:32:43 from Peter Geoghegan <pg(at)bowt(dot)ie>                     2022-05-26 03:17:33 from Bruce Momjian <bruce(at)momjian(dot)us>                      2022-05-26 03:39:20 from Michael Paquier <michael(at)paquier(dot)xyz>                       2022-05-26 05:16:09 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>                       2022-05-26 14:40:03 from Bruce Momjian <bruce(at)momjian(dot)us>                        2022-05-26 14:41:28 from Christophe Pettus <xof(at)thebuild(dot)com>                         2022-05-26 14:48:27 from Bruce Momjian <bruce(at)momjian(dot)us>                          2022-05-27 00:00:23 from Michael Paquier <michael(at)paquier(dot)xyz>                         2022-05-31 14:43:00 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                          2022-05-31 14:54:34 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                          2022-05-31 14:54:48 from Peter Geoghegan <pg(at)bowt(dot)ie>                          2022-05-31 20:50:16 from Andres Freund <andres(at)anarazel(dot)de>                      2022-05-26 05:29:11 from Петър Славов <pet(dot)slavov(at)gmail(dot)com>                   2022-05-27 23:13:32 from Andres Freund <andres(at)anarazel(dot)de>                    2022-05-28 06:26:55 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru> 📎                     2022-05-28 07:02:19 from Andres Freund <andres(at)anarazel(dot)de>                      2022-05-28 14:46:40 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru> 📎                       2022-05-28 19:34:13 from Andres Freund <andres(at)anarazel(dot)de>                        2022-05-29 04:15:15 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>                         2022-05-30 19:08:04 from Andres Freund <andres(at)anarazel(dot)de>                          2022-05-31 06:47:11 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>                        2022-05-30 06:54:08 from Michael Paquier <michael(at)paquier(dot)xyz>                         2022-05-30 14:11:39 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                         2022-05-30 19:10:04 from Andres Freund <andres(at)anarazel(dot)de>                          2022-05-30 20:24:35 from Peter Geoghegan <pg(at)bowt(dot)ie>                          2022-05-30 20:40:39 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                           2022-05-30 20:43:41 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                            2022-05-31 04:25:17 from Michael Paquier <michael(at)paquier(dot)xyz>                             2022-05-31 08:53:45 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                           2022-05-30 20:51:25 from Andres Freund <andres(at)anarazel(dot)de>                            2022-05-31 17:35:58 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                          2022-05-31 01:45:04 from Michael Paquier <michael(at)paquier(dot)xyz>                           2022-05-31 09:19:01 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                            2022-05-31 12:03:17 from Michael Paquier <michael(at)paquier(dot)xyz>                       2022-05-31 15:30:51 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                        2022-05-31 17:12:33 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>                         2022-05-31 18:42:32 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                          2022-05-31 18:45:38 from Peter Geoghegan <pg(at)bowt(dot)ie>                           2022-05-31 18:54:05 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                            2022-05-31 19:09:04 from Peter Geoghegan <pg(at)bowt(dot)ie>                             2022-05-31 19:19:26 from Andres Freund <andres(at)anarazel(dot)de>                              2022-05-31 19:45:09 from Peter Geoghegan <pg(at)bowt(dot)ie>                             2022-05-31 19:34:50 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                          2022-05-31 19:46:38 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>   2022-05-19 06:23:58 from Петър Славов <pet(dot)slavov(at)gmail(dot)com>
Lists:	pgsql-bugs

In response to

• Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY at 2022-05-30 20:43:41 from Alvaro Herrera

Responses

• Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY at 2022-05-31 08:53:45 from Alvaro Herrera

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Michael Paquier	2022-05-31 04:30:11	Re: Extension pg_trgm, permissions and pg_dump order
Previous Message	Kyotaro Horiguchi	2022-05-31 02:39:27	Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error