Re: Pg14 possible index corruption after reindex concurrently

2022-05-25 Thread Aleš Zelený
Hello, you are right it looks to be related, on our running system with connected users such an issue happens not only on primary keys but also on other (non-unique) indexes. I've checked all indexes using amcheck: select * from bt_index_check(index =>

Re: Pg14 possible index corruption after reindex concurrently

2022-05-24 Thread Aleš Zelený
Thanks for the bug link, I haven't found it. Ales út 24. 5. 2022 v 21:58 odesílatel Thomas Munro napsal: > On Wed, May 25, 2022 at 6:17 AM Aleš Zelený wrote: > > SELECT format('REINDEX SCHEMA CONCURRENTLY %I;', n.nspname) > > This may be related to bug #17485, discussed at: > > >

Re: Pg14 possible index corruption after reindex concurrently

2022-05-24 Thread Thomas Munro
On Wed, May 25, 2022 at 6:17 AM Aleš Zelený wrote: > SELECT format('REINDEX SCHEMA CONCURRENTLY %I;', n.nspname) This may be related to bug #17485, discussed at: https://www.postgresql.org/message-id/flat/17485-396609c6925b982d%40postgresql.org