ื ืงืขืจืขืงืืืื ืืขืืืื ื ืคืื ืื PostgreSQL DBMS 14.4 ืืื ืืืฉืืคื, ืืืึธืก ืืืืืึทื ืืืฅ ืึท ืขืจื ืกื ืคึผืจืึธืืืขื ืืืึธืก, ืืื ืืขืจ ืืืืขืจ ืฆืืฉืืื ืื, ืคืืจื ืฆื ืืืืขืืง ืืึทืื ืงืึธืจืืคึผืฆืืข ืืื ืื ืืขืงืกืื ืืืขื ืขืงืกืึทืงืืืืื ื ืื "CREATE INDEX CONCURRENTLY" ืืื "REINDEX CONCURRENTLY" ืงืึทืืึทื ืื. ืืื ืื ืื ืืขืงืกืื ืืืฉืืคื ืืื ืื ืกืคึผืขืกืืคืืขื ืงืึทืืึทื ืื, ืขืืืขืืข ืจืขืงืึธืจืืก ืงืขื ื ืืฉื ืืืื ืืขื ืืืขื ืืื ืืฉืืื, ืืืึธืก ืืืขื ืคืืจื ืฆื ืคืขืื ืืืง ืจืึธืื ืืืขื ืขืงืกืึทืงืืืืื ื ืกืขืืขืงื ืงืืืืจืื ืืื ืคึผืจืึธืืืขืืึทืืืง ืื ืืขืงืกืื.
ืฆื ืืึทืฉืืืกื ืฆื ื-ืืืื ืื ืืขืงืกืื ืืขื ืขื ืืึทืืืืืฉื, ืืืจ ืงืขื ืขื ื ืืฆื ืื ืืึทืคึฟืขื "pg_amcheck -heapallindexed db_name". ืืืื ืขืจืจืึธืจืก ืืขื ืขื ืืืืขื ืึทืคืืื ืึธืืขืจ ืื ืงืึทืืึทื ืื "CREATE INDEX CONCURRENTLY" ืืื "REINDEX CONCURRENTLY" ืืขื ืขื ืืขื ืืฆื ืืื ืคืจืืขืจืืืงื ืจืืืืกืื ืืื ืื ืืขืจืข ืืืืคึผืก ืคืื ืื ืืขืงืกืื (GiST, GIN, ืืื"ื ื), ื ืึธื ืึทืคึผืืืืืื ื ืฆื ืืืขืจืกืืข 14.4, ืขืก ืืื ืจืขืงืึทืืขื ืืื ืฆื ืืืจืืคืืจื ืจืขืื ืขืงืกืื ื ืืื ืื "ืจืขืื ืืขืงืกืื -ืึทืืข" ื ืืฆื ืึธืืขืจ ืื ืืึทืคึฟืขื "REINDEX CONCURRENTLY index_name."
ืืขืจ ืคึผืจืึธืืืขื ืึทืคืขืงืฅ ืืืืื ืื 14.x ืฆืืืืึทื, ืืืึธืก ืื ืงืืืืขื ืึธืคึผืืืืืืึทืืืึธื ืก ืืืึธืก ืืืกืฉืืืกื ืขืืืขืืข ืืจืึทื ืืึทืงืฉืึทื ื ืคึฟืึทืจืืื ืื ืืื ืื ืืืจืืคืืจืื ื ืคืื "CREATE INDEX CONCURRENTLY" ืืื "REINDEX CONCURRENTLY" ืืืขื ืืืจ ืืืจืืคืืจื ืื ืืืึทืงืืื ืึธืคึผืขืจืึทืฆืืข. ืืื ืึท ืจืขืืืืืึทื ืคืื ืื ืึธืคึผืืืืืืึทืืืึธื ืก, ืื ืืขืงืกืื ืืืฉืืคื ืืื ืงืึทื ืงืขืจืึทื ืืื ืืึธืืข ืืึธืื ื ืืฉื ืึทืจืืึทื ืืขืจืขืื ื ืขืืืขืืข ืืืคึผืืขืก ืืื ืงืืคึผืข ืืึผืจืื ืืืึธืก ืืขื ืขื ืืขืจืืืึทื ืืืงื ืึธืืขืจ ืืจืึทื ืืงืืืืื ืืขืฉืึทืก ืืื ืืขืงืก ืฉืึทืคืื ื.
ืืงืืจ: opennet.ru