5mins of Postgres E20: Bug in Postgres 14 with REINDEX / CREATE INDEX CONCURRENTLY & how to resolve
Today, we're going to talk about an important bug that was discovered in Postgres 14 and how you can verify if this affects you with the amcheck extension.
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
Tweet by Michael Paquier about the bug: / 1529046530832797698
Michael Paquier on Twitter: / michaelpq )
Original bug report on the PostgreSQL bug report mailing list: https://www.postgresql.org/message-id...
amcheck for Postgres: https://www.postgresql.org/docs/14/am...
pgbench - Benchmarking for PostgreSQL: https://www.postgresql.org/docs/curre...
Commit by Álvaro Herrera to revert the changes that introduced the bug: https://git.postgresql.org/gitweb/?p=...
Álvaro Herrera on Twitter: / alvherre
Using Postgres CREATE INDEX: Understanding operator classes, index types & more: https://pganalyze.com/blog/postgres-c...
eBook: Effective Indexing in Postgres: https://pganalyze.com/ebooks/postgres...