Kugadziriswa kuburitswa kwePostgreSQL DBMS 14.4 kwakagadzirwa, izvo zvinobvisa dambudziko rakakura iro, mune mamwe mamiriro ezvinhu, rinotungamira kune risingaonekwe data uori muma indexes paunenge uchiita iyo "CREATE INDEX CONCURRENTLY" uye "REINDEX CONCURRENTLY" mirairo. Mumaindex akagadzirwa uchishandisa mirairo yakataurwa, mamwe marekodhi anogona kusaverengerwa, izvo zvinozotungamira kushayikwa mitsara paunenge uchiita SARUDZA mibvunzo inosanganisira zvinetswa indexes.
Kuti uone kana B-muti indexes yakakuvadzwa, unogona kushandisa murairo "pg_amcheck -heapallindexed db_name". Kana zvikanganiso zvikaonekwa kana mirairo "GADZIRA INDEX CONCURRENTLY" uye "REINDEX CONCURRENTLY" yakashandiswa mukuburitswa kwakapfuura nemamwe marudzi emaindex (GiST, GIN, nezvimwewo), mushure mekuvandudza kune vhezheni 14.4, zvinokurudzirwa kuita reindexing uchishandisa iyo " reindexdb -zvose" zvinoshandiswa kana murairo "REINDEX CONCURRENTLY index_name."
Dambudziko rinobata chete 14.x bazi, iyo yaisanganisira optimizations iyo isingabatanidzi zvimwe zvekutengesa zvine chekuita nekuitwa kwe "CREATE INDEX CONCURRENTLY" uye "REINDEX CONCURRENTLY" paunenge uchiita basa reVACUUM. Nekuda kweizvi optimizations, indexes yakagadzirwa muCONCURRENTLY modhi haina kusanganisira mamwe matuples mumirwi ndangariro akagadziridzwa kana kuderedzwa panguva yekugadzira index.
Source: opennet.ru