Tokollo e lokisoang ea PostgreSQL DBMS 14.4 e bōpiloe, e felisang bothata bo tebileng boo, tlas'a maemo a itseng, bo lebisang ho bobolu bo sa bonahaleng ba data ka li-index ha u phethahatsa litaelo tsa "CREATE INDEX CONCURRENTLY" le "REINDEX CONCURRENTLY". Ho li-index tse entsoeng ho sebelisoa litaelo tse boletsoeng, litlaleho tse ling li ka 'na tsa se ke tsa nkoa, e leng se tla lebisa ho sieo ha mela ha ho etsoa KHETHA lipotso tse amanang le li-index tse nang le mathata.
Ho fumana hore na li-index tsa B-tree li senyehile, u ka sebelisa taelo "pg_amcheck -heapallindexed db_name". Haeba liphoso li tsejoa kapa litaelo tsa "CREATE INDEX CONCURRENTLY" le "REINDEX CONCURRENTLY" li ne li sebelisoa liphatlalatsong tse fetileng le mefuta e meng ea li-index (GiST, GIN, joalo-joalo), ka mor'a ho ntlafatsa ho version 14.4, ho kgothaletswa ho etsa reindexing ka ho sebelisa "reindexdb -all" utility kapa taelo "REINDEX CONCURRENTLY index_name."
Bothata bo ama feela lekala la 14.x, le neng le kenyelletsa lintlafatso tse sa kenyelletseng litšebelisano tse ling tse amanang le ts'ebetso ea "CREATE INDEX COCURRENTLY" le "REINDEX CONCURRENTLY" ha u etsa ts'ebetso ea VACUUM. Ka lebaka la lintlafatso tsena, li-index tse entsoeng ka mokhoa oa CONCURRENTLY ha li kenyeletse likopi tse ling tsa memori ea qubu tse ntlafalitsoeng kapa tsa fokotsoa nakong ea tlhahiso ea index.
Source: opennet.ru