Kev kho qhov tso tawm ntawm PostgreSQL DBMS 14.4 tau tsim, uas tshem tawm qhov teeb meem loj uas, nyob rau hauv qee qhov xwm txheej, ua rau pom tsis pom cov ntaub ntawv kev noj nyiaj txiag hauv kev ntsuas thaum ua tiav "CREATE INDEX CONCURRENTLY" thiab "REINDEX CONCURRENTLY" cov lus txib. Hauv cov indexes tsim siv cov lus txib, qee cov ntaub ntawv yuav tsis raug coj mus rau hauv tus account, uas yuav ua rau cov kab uas ploj lawm thaum ua tiav SELECT queries uas muaj teeb meem indexes.
Txhawm rau txiav txim siab seb B-ntoo qhov ntsuas tau puas lawm, koj tuaj yeem siv cov lus txib "pg_amcheck -heapallindexed db_name". Yog tias qhov yuam kev raug txheeb xyuas lossis cov lus txib "CREATE INDEX CONCURRENTLY" thiab "REINDEX CONCURRENTLY" tau siv hauv kev tshaj tawm yav dhau los nrog lwm hom kev ntsuas (GiST, GIN, thiab lwm yam), tom qab hloov kho rau version 14.4, nws raug nquahu kom ua reindexing siv lub "reindexdb -tag nrho" cov nqi hluav taws xob lossis cov lus txib "REINDEX CONCURRENTLY index_name."
Qhov teeb meem cuam tshuam tsuas yog 14.x ceg, uas suav nrog kev ua kom zoo dua uas tsis suav nrog qee qhov kev lag luam cuam tshuam nrog kev ua tiav ntawm "CREATE INDEX CONCURRENTLY" thiab "REINDEX CONCURRENTLY" thaum ua haujlwm VACUUM. Raws li qhov txiaj ntsig ntawm qhov kev ua kom zoo dua no, indexes tsim nyob rau hauv CONCURRENTLY hom tsis suav nrog qee qhov tuples hauv heap nco uas tau hloov kho lossis txiav tawm thaum lub sijhawm tsim qhov ntsuas.
Tau qhov twg los: opennet.ru