Kutulutsidwa koyenera kwa PostgreSQL DBMS 14.4 kwapangidwa, komwe kumathetsa vuto lalikulu lomwe, nthawi zina, limayambitsa ziphuphu zosaoneka za data mu indexes pochita "CREATE INDEX CONCURRENTLY" ndi "REINDEX CONCURRENTLY" malamulo. M'ma index omwe amapangidwa pogwiritsa ntchito malamulo omwe atchulidwa, zolemba zina sizingaganizidwe, zomwe zingapangitse mizere yosowa pochita zisanja mafunso okhudzana ndi zovuta.
Kuti muwone ngati ma index a B-tree awonongeka, mutha kugwiritsa ntchito lamulo "pg_amcheck -heapallindexed db_name". Ngati zolakwika zazindikirika kapena malamulo akuti "CREATE INDEX CONCURRENTLY" ndi "REINDEX CONCURRENTLY" adagwiritsidwa ntchito m'mabuku am'mbuyomu ndi mitundu ina ya indexes (GiST, GIN, etc.), mutatha kusinthidwa kukhala 14.4, tikulimbikitsidwa kuti mugwiritse ntchito "reindexdb -all" zofunikira kapena lamulo "REINDEX CONCURRENTLY index_name."
Vutoli limakhudza nthambi ya 14.x yokha, yomwe imaphatikizapo kukhathamiritsa komwe sikumaphatikizapo zochitika zina zokhudzana ndi kuchitidwa kwa "CREATE INDEX CONCURRENTLY" ndi "REINDEX CONCURRENTLY" pochita ntchito ya VACUUM. Chifukwa cha kukhathamiritsa kumeneku, ma index omwe adapangidwa mu CONCURRENTLY mode sanaphatikizepo ma tuple mu mulu wamakumbukiro omwe adasinthidwa kapena kuchepetsedwa popanga index.
Source: opennet.ru