An ƙirƙiri sakin gyara na PostgreSQL DBMS 14.4, wanda ke kawar da babbar matsala wanda, a cikin wasu yanayi, yana haifar da ɓarna ga bayanan da ba a iya gani a cikin fihirisa lokacin aiwatar da umarnin "CREATE INDEX CONCURRENTLY" da "REINDEX CONCURRENTLY". A cikin firikwensin da aka ƙirƙira ta amfani da ƙayyadaddun umarni, wasu bayanan ƙila ba za a yi la'akari da su ba, wanda zai haifar da ɓacewar layuka yayin aiwatar da tambayoyin SELECT da suka haɗa da maƙasudin matsala.
Don sanin ko alamun B-itace sun lalace, zaku iya amfani da umarnin "pg_amcheck -heapallindexed db_name". Idan an gano kurakurai ko umarnin "CREATE INDEX CONCURRENTLY" da "REINDEX CONCURRENTLY" an yi amfani da su a cikin abubuwan da suka gabata tare da wasu nau'ikan fihirisa (GiST, GIN, da sauransu), bayan an sabunta zuwa sigar 14.4, ana ba da shawarar yin reindexing ta amfani da "reindexdb -all" mai amfani ko umarni "REINDEX CONCURRENTLY index_name."
Matsalar tana shafar reshe na 14.x kawai, wanda ya haɗa da haɓakawa waɗanda ke keɓance wasu ma'amaloli masu alaƙa da aiwatar da "CREATE INDEX CONCURRENTLY" da "REINDEX CONCURRENTLY" lokacin yin aikin VACUUM. Sakamakon waɗannan ingantawa, fihirisar da aka ƙirƙira a cikin yanayin DAYA ba su haɗa da wasu tuples a cikin ƙwaƙwalwar ajiya waɗanda aka sabunta ko yanke yayin ƙirƙirar fihirisar ba.
source: budenet.ru