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

От

Christophe Pettus

Тема

Дата

26 мая 2022 г. в 14:41:28

Msg-id

BB3FB2D1-9796-442B-AF11-08DFD0BF0F57@thebuild.com

обсуждение

Ответ на

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

Список

pgsql-bugs

Дерево обсуждения

BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY PG Bug reporting form <noreply@postgresql.org> 18 мая 2022 г. в 10:42:13

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 19 мая 2022 г. в 04:22:44

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Петър Славов <pet.slavov@gmail.com> 19 мая 2022 г. в 06:23:58

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 19 мая 2022 г. в 04:32:46

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Петър Славов <pet.slavov@gmail.com> 19 мая 2022 г. в 05:24:27

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 19 мая 2022 г. в 08:02:32

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 19 мая 2022 г. в 12:03:56

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 23 мая 2022 г. в 05:40:16

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 23 мая 2022 г. в 08:07:44

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 23 мая 2022 г. в 09:02:40

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 23 мая 2022 г. в 18:13:12

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 24 мая 2022 г. в 01:08:29

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 23 мая 2022 г. в 10:49:02

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 23 мая 2022 г. в 13:06:10

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 23 мая 2022 г. в 18:18:10

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 24 мая 2022 г. в 01:20:02

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 24 мая 2022 г. в 02:19:50

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 24 мая 2022 г. в 09:02:12

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 24 мая 2022 г. в 16:37:02

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 24 мая 2022 г. в 18:15:42

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 24 мая 2022 г. в 18:38:07

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 24 мая 2022 г. в 19:01:33

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 25 мая 2022 г. в 11:44:54

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Robert Haas <robertmhaas@gmail.com> 25 мая 2022 г. в 12:39:14

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 25 мая 2022 г. в 16:43:22

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 25 мая 2022 г. в 17:08:21

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 27 мая 2022 г. в 23:13:32

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 28 мая 2022 г. в 06:26:55

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 28 мая 2022 г. в 07:02:19

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 28 мая 2022 г. в 14:46:40

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 28 мая 2022 г. в 19:34:13

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 29 мая 2022 г. в 04:15:15

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 30 мая 2022 г. в 19:08:04

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 31 мая 2022 г. в 06:47:11

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 30 мая 2022 г. в 06:54:08

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 30 мая 2022 г. в 14:11:39

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 30 мая 2022 г. в 19:10:04

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 30 мая 2022 г. в 20:40:39

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 30 мая 2022 г. в 20:43:41

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 31 мая 2022 г. в 04:25:17

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 08:53:45

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 30 мая 2022 г. в 20:51:25

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 17:35:58

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 30 мая 2022 г. в 20:24:35

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 31 мая 2022 г. в 01:45:04

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 09:19:01

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 31 мая 2022 г. в 12:03:17

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 15:30:51

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 31 мая 2022 г. в 17:12:33

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 18:42:32

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 19:46:38

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 31 мая 2022 г. в 18:45:38

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 18:54:05

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 31 мая 2022 г. в 19:09:04

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 31 мая 2022 г. в 19:19:26

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 31 мая 2022 г. в 19:45:09

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 19:34:50

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Robert Haas <robertmhaas@gmail.com> 25 мая 2022 г. в 17:17:49

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 25 мая 2022 г. в 17:32:43

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Bruce Momjian <bruce@momjian.us> 26 мая 2022 г. в 03:17:33

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Петър Славов <pet.slavov@gmail.com> 26 мая 2022 г. в 05:29:11

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 26 мая 2022 г. в 03:39:20

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 26 мая 2022 г. в 05:16:09

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Bruce Momjian <bruce@momjian.us> 26 мая 2022 г. в 14:40:03

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Christophe Pettus <xof@thebuild.com> 26 мая 2022 г. в 14:41:28

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 14:43:00

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Alvaro Herrera <alvherre@alvh.no-ip.org> 31 мая 2022 г. в 14:54:34

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 31 мая 2022 г. в 20:50:16

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 31 мая 2022 г. в 14:54:48

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Bruce Momjian <bruce@momjian.us> 26 мая 2022 г. в 14:48:27

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 27 мая 2022 г. в 00:00:23

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 25 мая 2022 г. в 04:00:47

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 25 мая 2022 г. в 04:20:49

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Greg Stark <stark@mit.edu> 24 мая 2022 г. в 21:11:12

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 24 мая 2022 г. в 22:24:33

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Michael Paquier <michael@paquier.xyz> 25 мая 2022 г. в 00:59:27

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 24 мая 2022 г. в 18:37:05

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Peter Geoghegan <pg@bowt.ie> 24 мая 2022 г. в 17:38:14

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andres Freund <andres@anarazel.de> 24 мая 2022 г. в 18:46:54

Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY Andrey Borodin <x4mmm@yandex-team.ru> 24 мая 2022 г. в 10:08:33

> On May 26, 2022, at 07:40, Bruce Momjian  wrote:
> 
> Uh, if people don't know if they have used CREATE/REINDEX CONCURRENTLY
> in PG 14.0+, they are going to need to run amcheck on all btree indexes
> and reindex all non-btree indexes?  That is going to be a painful
> message to deliver, and hear.  :-(

Unless we are 100% sure that amcheck will never return a false negative in this situation, we may have to recommend reindexing everything.  Ouch.

В списке pgsql-bugs по дате отправления

Предыдущее

От: Bruce Momjian

Дата: 26 мая 2022 г. в 14:40:03

Сообщение: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY

Следующее

От: Bruce Momjian

Дата: 26 мая 2022 г. в 14:48:27

Сообщение: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY