Ngemuva cishe konyaka wentuthuko, ukukhishwa kwe igatsha elisha elizinzile le- I-PostgreSQL 13, Eqokomisa ukusebenza okuphezulu, kanye nokufakwa kwezici ezintsha.
Kulabo abangakajwayelani nePostgreSQL, kufanele wazi ukuthi yaziwa nangokuthi iPostgres kanye lolu uhlelo lokulawulwa kwedatha oluhlobene (RDBMS) mahhala, umthombo ovulekile, okuhlose ukunikela ngemininingwane egciniwe ngokuya ngokwandiswa nokuhambisana namazinga obuchwepheshe.
Yenzelwe ukuphatha imisebenzi ehlukahlukene, kusuka kumishini elula kuya ezinqolobaneni zedatha noma izinsizakalo zewebhu ezinabasebenzisi abaningi abafanayo.
Yini okusha ku-PostgreSQL 13?
Kule nguqulo entsha kugqanyisiwe lokho ukuqoshwa kwerekhodi kwasetshenziswa ezinkombeni ze-B-tree, ukunika amandla ukusebenza kombuzo okwandisiwe nokunciphisa ukusetshenziswa kwesikhala sediski lapho kukhonjwa amarekhodi ngemininingwane eyimpinda.
Ukuzikhohlisa kwenziwa ngokwethula umshayeli ngezikhathi ezithile ehlanganisa amaqembu ezimpinda eziphindwe kabili bese ingena esikhundleni sezimpinda ezinereferensi yekhophi elilodwa eligciniwe.
Futhi futhi ukusebenza kangcono kwemibuzo kusetshenziswa imisebenzi ehlanganisiwe kuyagqanyiswa, amasethi aqoqiwe (IZILUNGISELELO ZOKUQALA) noma amatafula ahlukanisiwe (partitsirovannye).
Ukusebenziseka okuhle kuhlobene nokusetshenziswa kwama-hashes ngokungeziwe esikhundleni sedatha yangempela, evimbela ukubeka yonke idatha kwimemori lapho icubungula imibuzo emikhulu. Ukwahlukanisa kwandise inani lezimo lapho ukwahlukaniswa kungasuswa noma kuhlanganiswe khona.
Tambien kungeze ikhono lokusebenzisa izibalo ezithuthukile yenziwe ngumyalo «DALA IZIBALO»Ukwenza ngcono ukusebenza kahle kokuhlelwa kombuzo equkethe "OR" imishwana noma uhlu losesho olusebenzisa "IN" noma "ANY".
Ukuhlanzwa kwenkomba ngesikhathi sokusebenza I-VACUUM kuyashesha ngenxa yokuhlanganiswa kokuqoqwa kukadoti kuma-indices. Ngepharamitha entsha «PHAMBILI»Umphathi angachaza inani lemicu ezoqaliswa ngasikhathi sinye se- I-VACUUM.
Kungezwe ukusekelwa kokuhlungwa okwengeziwe, okukuvumela ukuthi usebenzise idatha ehlelwe esigabeni esedlule ukusheshisa ukuhlunga ezigabeni zakamuva zokucubungula isicelo.
Ukuze unike amandla ukusetshenziswa okusha, isihleli sombuzo sinikeza izilungiselelo » vumela_incremental_sort ', Okunikwe amandla ngokuzenzakalela.
Kungezwe amandla okukhawulela usayizi wezindawo zokuphindaphindeka, ekuvumela ukuthi uqinisekise ngokuzenzakalela ukugcinwa kwamasegimenti wokubhala ngemuva kwe-log (WAL) aze amukelwe yiwo wonke amaseva okulindile athola ukuphindaphindwa. Izikhala zokuphindaphindeka zivimbela neseva eyinhloko ekususeni imigqa, engaholela ezingxabanweni noma ngabe iseva yesibili ingaxhunyiwe ku-inthanethi.
De ezinye izinguquko ezigqamile yale nguqulo entsha:
- Ipharamitha max_slot_wal_keep_size manje ingasetshenziselwa ukunciphisa usayizi omkhulu wamafayela we-WAL ukugwema ukuphela kwesikhala sediski.
- Amathuba wokuqapha umsebenzi we-DBMS anwetshiwe: kumyalo QAPHELA, ukuboniswa kwezibalo ezingeziwe ekusetshenzisweni kwe-WAL-log kunikeziwe.
- Kungezwe umyalo omusha pg_verifybackup ukuqinisekisa ubuqotho bezipele ezidalwe ngumyalo pg_basebackup.
- Lapho usebenza noJSON usebenzisa ama-opharetha jsonpath, kuvunyelwe ukusebenzisa umsebenzi isikhathi () ukuguqula amafomethi wesikhathi (izintambo ze-ISO 8601 nezinhlobo zesikhathi sendabuko zePostgreSQL).
- Umsebenzi owakhelwe ngaphakathi ungeziwe gen_random_uuid () ukukhiqiza i-UUID v4.
Uhlelo lokwahlukanisa lunikeza ukusekelwa okugcwele kokuphindaphindeka okunengqondo nangaphambi kwezimbangela zezinga lomugqa. - Umqondo wezandiso ezethembekile usetshenzisiwe, ongafakwa abasebenzisi abajwayelekile abangenawo amalungelo okuphatha we-DBMS.
- Uhlu lwala ma-plugins luchazwe ngaphambilini futhi lunganwetshwa ngumsebenzisi omkhulu. Ama-plugins athenjiwe afaka phakathi pgcrypto, tablefunc, hstore, njll.
- Ithebula langaphandle lijoyina indlela yesiqukathi sedatha yangaphandle (okuthunyelwe_fdw) isekela ukuqinisekiswa okusekelwe kusitifiketi.
Ekugcineni, kushiwo ukuthi izibuyekezo zegatsha elisha zizoshicilelwa iminyaka emihlanu kuze kube nguNovemba 2025.
Umthombo: https://www.postgresql.org/