ืงืขืจืขืงืืืื ืืขืจืืืึทื ืืืงืื ืืขื ืืขื ืขื ืืืฉืขื ืขืจืืืืึทื ืคึฟืึทืจ ืึทืืข ืฉืืืฆื PostgreSQL ืฆืืืืืื: 14.3, 13.7, 12.11, 11.16 ืืื 10.22. ืื 10.x ืฆืืืืึทื ืืื ืึทืคึผืจืึธืืืฉืื ื ืื ืกืืฃ ืคืื ืฉืืืฆื (ืืขืจืืืึทื ืืืงืื ืืขื ืืืขื ืืืื ืืืฉืขื ืขืจืืืืึทื ืืื ื ืืืืขืืืขืจ 2022). ืื ืืขืืืื ื ืคืื ืืขืจืืืึทื ืืืงืื ืืขื ืคึฟืึทืจ ืื 11.x ืฆืืืืึทื ืืืขื ืืขืืืืขืจื ืืื ื ืืืืขืืืขืจ 2023, 12.x ืืื ื ืืืืขืืืขืจ 2024, 13.x ืืื ื ืืืืขืืืขืจ 2025, 14.x ืืื ื ืืืืขืืืขืจ 2026.
ืื ื ืืึทืข ืืืขืจืกืืขืก ืคืึธืจืฉืืึธืื ืืขืจ ืืื 50 ืคืืงืกืื ืืื ืขืืืืื ืืจื ืื ืืืึทืื ืขืจืึทืืืืืื CVE-2022-1552 ืคึฟืึทืจืืื ืื ืืื ืื ืคืืืืงืืื ืฆื ืืืืคึผืึทืก ืื ืืคืืขืืื ืืขืจืืงืืื ืคืื ืืืจืืคืืจืื ื ืคืื ืคึผืจืืืืืืืืฉื ืึทืคึผืขืจืืืฉืึทื ื Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER ืืื pg_amcheck. ืึท ืึทืืึทืงืขืจ ืืื ืื ืืืืืึธืจืืืขื ืฆื ืฉืึทืคึฟื ื ืื-ืฆืืึทืืืืืึทืืืง ืึทืืืืฉืขืงืฅ ืืื ืงืืื ืกืืึธืจืืืืฉ ืกืืขืืข ืงืขื ืขื ืึธื ืืึทืื ืึทืจืืืืจืึทืจืืฉ SQL ืคืึทื ืืงืฉืึทื ื ืฆื ืืืื ืขืงืกืึทืงืืืืึทื ืืื ืืืึธืจืฆื ืคึผืจืืืืืืึทืืืฉืึทื ืืฉืขืช ืึท ืคึผืจืืืืืืืืฉื ืืึทื ืืฆืขืจ ืคึผืขืจืคืึธืจืื ืื ืืืืื ืึทืคึผืขืจืืืฉืึทื ื ืืืึธืก ืืืืจืงื ืื ืึทืืึทืงืขืจ ืก ืืืืคืขืฅ. ืืื ืืึทืืื ืืขืจ, ืขืงืกืคึผืืืืืืืฉืึทื ืคืื ืื ืืืึทืื ืขืจืึทืืืืืื ืงืขื ืขื ืคึผืึทืกืืจื ืืขืฉืึทืก ืึธืืึทืืึทืืืง ืจืืื ืืงืื ื ืคืื ืื ืืึทืืึทืืืืก ืืืขื ืื ืึทืืืึธืืืึทืงืืื ืืึทื ืืืขืจ ืืื ืขืงืกืึทืงืืืืึทื.
ืืืื ืืขืจ ืืขืจืืืึทื ืืืงื ืืื ื ืื ืืขืืืขื, ืื ืืืึธืจืงืึทืจืึธืื ื ืคึฟืึทืจ ืืืึทืงืื ื ืืขื ืึทืจืืืกืืขืื ืืื ืฆื ืืืกืืืืึทื ืึทืืืึธืืืึทืงืืื ืืื ื ืืฉื ืืืจืืคืืจื REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW ืืื CLUSTER ืึทืคึผืขืจืืืฉืึทื ื ืืื ืึท ืืืึธืจืฆื ืืึทื ืืฆืขืจ, ืืื ื ืืฉื ืืืืคื pg_amcheck ืึธืืขืจ ืืืงืขืจื ืืื ืืึทืื ืคึฟืื ืึท ืืึทืงืึทืคึผ ืืืฉืืคื ืืืจื pg_dump. . ืขืงืกืึทืงืืืืื ื ืืืึทืงืืื ืืื ืืขืืืืื ืืืืขืจ, ืืื ืืื ืงืืื ืืึทืคึฟืขื ืึธืคึผืขืจืึทืฆืืข, ืืื ืืึทื ื ืืื ืื ืึทืืืืฉืขืงืฅ ืืืึธืก ืคึผืจืึทืกืขืกื ืืขื ืขื ืึธืื ื ืืืจื ืืจืึทืกืืื ื ืืฆืขืจืก.
ืื ืืขืจืข ืขื ืืขืจืื ืืขื ืืื ืื ื ืืึทืข ืจืืืืกืื ืึทืจืืึทื ื ืขืืขื ืึทืคึผืืืืืื ื ืื JIT ืงืึธื ืฆื ืึทืจืืขืื ืืื LLVM 14, ืึทืืึทืืื ื ืื ื ืืฆื ืคืื database.schema.table ืืขืืคึผืืึทืืขืก ืืื ืื psql, pg_dump ืืื pg_amcheck ืืืืืืึทืืื, ืคืืงืกืืจ ืคึผืจืึธืืืขืืก ืืืึธืก ืคืืจื ืฆื ืงืึธืจืืคึผืฆืืข ืคืื โโโโืืืกื ืื ืืขืงืกืื ืืืืขืจ ืืืจื ืฉืคืืืื, ืคืึทืืฉ. ืจืึทืื ืืื ื ืคืื ืืืึทืืืขืก ืืื ืื ืคึฟืึธืจืืึทื ืขืคึผืึธืก ืืงืกืืจืึทืงืืื ืคืื ืืขืืึทืืขื ืืึทืื, ืคืึทืืฉ ืกืงืขืืืฉืืืขืจ ืึธืคึผืขืจืึทืฆืืข ืืืขื ื ืืฆื ืืืกืื ืืงืจืึทื ืึทืก ืืืืึทื ืคึฟืจืืื, ืคืึทืืฉ ืกืึธืจืืืจืื ื ืคืื ืืืฉ ืจืึธืื ืืืขื ื ืืฆื ืื CLUSTER ืืืืกืืจืืง ืืืืฃ ืื ืืขืงืกืื ืืื ืืืืกืืจืืง-ืืืืืจื ืฉืืืกืืขื, ืืึทืื ืึธื ืืืขืจ ืจืขืื ืฆื ืึท ืึทืื ืึธืจืืึทื ืืขืจืืึทื ืืืฉืึทื ืืื ื ืึธื ืงืึทื ืกืืจืึทืงืืื ื ืึท ืกืึธืจืืื GiST ืืื ืืขืงืก, ืืขืืืึทืง ืืขืฉืึทืก ืืืืืฉืึทื ืคึผืึทืจืืืฉืึทื ื ืืื ืืขืงืก, ืจืึทืกืข ืฆืืฉืืึทื ื ืฆืืืืฉื ืื DROP TABLESPACE ืึธืคึผืขืจืึทืฆืืข ืืื ืื ืืฉืขืงืคึผืืื ื.
ืืื ืืขืจืฆื, ืืืจ ืงืขื ืขื ืืึธื ืื ืืขืืืื ื ืคืื ืื pg_ivm 1.0 ืคืึทืจืืขื ืืขืจืื ื ืืื ืื ืืืคึผืืึทืืขื ืืืืฉืึทื ืคืื IVM (ืื ืงืจืขืืขื ืืึทื View ืืึทืื ืืขื ืึทื ืกืข) ืฉืืืฆื ืคึฟืึทืจ PostgreSQL 14. IVM ืึธืคืคืขืจืก ืึทื ืึธืืืขืจื ืึทืืืื ืืืขื ืฆื ืืขืจืืืึทื ืืืงื ืืึทืืืจืืึทืืืืื ืงืืงื, ืืขืจ ืขืคืขืงืืืื ืืืื ืขื ืืขืจืื ืืขื ืืืืจืงื ืึท ืงืืืื ืืืื ืคืื ืื ืืืื ืื ื. IVM ืึทืืึทืื ืืึทืืืจืืึทืืืืื ืงืืงื ืฆื ืืืื ืืืืื ืืขืจืงืืืืงื ืืื ืืืืื ืื ืงืจืึทืืขื ืืึทื ืขื ืืขืจืื ืืขื, ืึธื ืจืืงืึทืืงืืึทืืืืืื ื ืื ืืืื ืื ื ืืื ืื REFRESH MATERIALIZED VIEW ืึธืคึผืขืจืึทืฆืืข.
ืืงืืจ: opennet.ru