O se faʻasaʻoga faʻasaʻo o le PostgreSQL DBMS 14.4 ua faia, lea e faʻaumatia ai se faʻafitauli matuia lea, i lalo o nisi tulaga, e taʻitaʻia ai faʻamatalaga le vaaia i faʻamaumauga pe a faʻatinoina le "CREATE INDEX CONCURRENTLY" ma le "REINDEX CONCURRENTLY" poloaiga. I faʻasinomaga na faia e faʻaaoga ai faʻatonuga faʻapitoa, o nisi faʻamaumauga e le mafai ona amanaia, lea o le a taʻitaʻia ai laina misi pe a faʻatinoina fesili FILIFILI e aofia ai faʻafitauli faʻafitauli.
Ina ia iloa pe ua faʻaleagaina faʻamatalaga B-laau, e mafai ona e faʻaogaina le poloaiga "pg_amcheck –heapallindexed db_name". Afai e iloa mea sese poʻo le faʻatonuga "CREATE INDEX CONCURRENTLY" ma le "REINDEX CONCURRENTLY" na faʻaaogaina i faʻasalalauga talu ai ma isi ituaiga o faʻasino igoa (GiST, GIN, ma isi), pe a uma ona faʻafouina i le version 14.4, e fautuaina e toe faʻaaogaina le faʻaaogaina o le "reindexdb -all" aoga poʻo le faʻatonuga "REINDEX CONCURRENTLY index_name."
O le faʻafitauli e aʻafia ai naʻo le 14.x lala, lea e aofia ai faʻataʻitaʻiga e le aofia ai nisi o fefaʻatauaiga e fesoʻotaʻi ma le faʻataunuʻuina o le "CREATE INDEX CONCURRENTLY" ma le "REINDEX CONCURRENTLY" pe a faʻatinoina le gaioiga VACUUM. O le i'uga o nei su'esu'ega, o fa'ailoga na faia i le CONCURRENTLY mode e le'i aofia ai ni tuple i fa'aputuga manatua na fa'afou pe tipi i le taimi o le fa'atupuina o fa'ailoga.
puna: opennet.ru