O faʻafouga faʻasaʻo ua faʻatupuina mo lala PostgreSQL lagolago uma: 14.3, 13.7, 12.11, 11.16 ma le 10.22. Ole lala ole 10.x ua latalata ile fa'ai'uga ole lagolago (o fa'afouga o le a faia seia oo ia Novema 2022). O le tatalaina o faʻamatalaga mo le lala 11.x o le a tumau seia oʻo ia Novema 2023, 12.x seʻia Novema 2024, 13.x seʻia Novema 2025, 14.x seʻia Novema 2026.
O lomiga fou e ofoina atu le sili atu i le 50 faʻamautu ma faʻaumatia le faʻafitauli CVE-2022-1552 e fesoʻotaʻi ma le mafai ona faʻamalo le tuʻuesea o le faʻatinoina o galuega faʻapitoa Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER ma pg_amcheck. O se tagata osofa'i e iai le pule e fa'atupu ai mea e le tumau i so'o se polokalame e teu ai e mafai ona fa'atupu ai le fa'atinoina o galuega a le SQL fa'atasi ma fa'amanuiaga a'a a'o fa'atinoina e se tagata fa'apitoa ia gaioiga o lo'o i luga e a'afia ai le mea a le tagata osofa'i. Aemaise lava, o le faʻaogaina o le faʻafitauli e mafai ona tupu i le taimi o le faʻamamaina otometi o le faʻamaumauga pe a faʻataunuʻu le faʻaogaina o le autovacuum.
Afai e le mafai le faʻafouga, o le fofo mo le polokaina o le mataupu o le tapeina lea o le autovacuum ma aua le faia REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, ma CLUSTER operations e avea o se aʻa, ae le o le taʻavale pg_amcheck pe toe faʻafoʻi mea mai se faʻamaumauga na faia e pg_dump . O le fa'atinoina o le VACUUM e manatu e saogalemu, e pei o so'o se fa'atonuga, pe afai o mea o lo'o fa'agaioia e umia e tagata fa'atuatuaina.
O isi suiga i faʻasalalauga fou e aofia ai le faʻafouina o le JIT code e galulue ai ma le LLVM 14, faʻatagaina le faʻaogaina o database.schema.table templates i le psql, pg_dump ma pg_amcheck utilities, faʻapipiʻiina o faʻafitauli e oʻo atu ai i le faʻaleagaina o faʻamatalaga GiST i luga ole ltree koluma, le saʻo. fa'avasegaina o tau i le fa'asologa o taimi na maua mai i fa'amaumauga vaeluaga, le sa'o le fa'atulagaina o fa'atonuga pe a fa'aogaina fesili mamao mamao, fa'avasegaina le sa'o o laina laulau pe a fa'aogaina le CLUSTER fa'amatalaga i fa'amatalaga fa'atasi ma fa'amatalaga fa'amaufa'ailoga, leiloa fa'amatalaga ona o se fa'agata fa'afuase'i pe a mae'a. fausia se fa'ailoga fa'avasegaina o le GiST, fa'agata i le tapeina o fa'ailoga vaelua, tulaga tau ta'aloga i le va o le DROP TABLESPACE fa'agaioiga ma le nofoaga e siaki ai.
E le gata i lea, e mafai ona tatou maitauina le faʻatagaina o le pg_ivm 1.0 faʻaopoopoga faʻatasi ai ma le faʻatinoina o le IVM (Incremental View Maintenance) lagolago mo PostgreSQL 14. IVM e ofoina atu se isi auala e faʻafouina ai manatu faʻaalia, sili atu le aoga pe a aʻafia suiga i se vaega itiiti o le vaaiga. E fa'atagaina e le IVM ona fa'afou fa'amatalaga fa'apitoa e fa'afou fa'atasi ma na'o suiga fa'aopoopo, e aunoa ma le toe fuaina o le va'aiga e fa'aaoga ai le fa'agaioiga REFRESH MATERIALIZED VIEW.
puna: opennet.ru