formed Correct production of the POSTGResQL DBMS 14.4, in which a serious problem is eliminated, under certain circumstances leading to Incordeal damage to the data in indices when performing commands “Create Index Concurrently” and “Reindex Concurrently”. The indexes created using these commands may not take into account some records, which will lead to the passage of individual lines when performing the Select Querries with the involvement of problematic indices.
to determine the fact of damage to the B-Tree indexes, you can use the command “PG_AMCHECK –heapallindExed Name_BD “. If errors are identified or used in past releases of the Create Index Concurrently commands and “Reindex Concurrently” with other types of indices (Gist, GIN, etc.), after updating to version 14.4, it is recommended to refindex the ReindExdb –all “reindex” or command “Reindex Concurrently Name_Index”.
The problem is subject only to the 14.x branch, which included optimizations that exclude the Vacuum operations some transactions associated with the implementation of Create Index Concurrently and Reindex Concurrently. As a result of the application of these optimizations in the “Concurrently” mode, the indices did not fall in the HEAP-memory motorcade, which were updated or cut during the creation of the index.