Emva phantse konyaka wophuhliso, ukukhutshwa kwe isebe elitsha elizinzileyo le IPostgreSQL 13, ebalaselisa ukusebenza okuphezulu, kunye nokubandakanywa kweempawu ezintsha.
Kulabo abangaqhelekanga ngePostgreSQL, kuya kufuneka uyazi ukuba yaziwa ngokuba yiPostgres kunye Le yinkqubo yolawulo lwesiseko sedatha (I-RDBMS) simahla, vula umthombo, ejolise ekunikezeleni ngesiseko sedatha ngokubhekisele kukolula nokuthobela imigangatho yobugcisa.
Yenzelwe ukuphatha imisebenzi eyahlukeneyo, Ukusuka koomatshini abalula ukuya kwiindawo zokugcina idatha okanye iinkonzo zewebhu ezinabasebenzisi abaninzi ngaxeshanye.
Yintoni entsha kwiPostgreSQL 13?
Kule nguqulo intsha icacisiwe ukuba irekhodi lokuncitshiswa kwamiliselwa kwizalathiso zomthi we-B, Ukwenza ukwanda kokusebenza kombuzo kunye nokunciphisa ukusetyenziswa kwediski xa kusalathiswa iirekhodi ezinedatha ephindiweyo.
Ukuphinda kwenziwe kwenziwa ngokusungula umqhubi ngamaxesha athile edibanisa amaqela aphindwe kabini aphindaphindiweyo kunye nezalathiso kwikopi enye egciniweyo.
Kwaye kwakhona Ukusebenza okungcono kwemibuzo usebenzisa imisebenzi ehlanganisiweyo kuyacaciswa, iiseti zamaqela (UKUSETYENZISWA KWAMAQELA) okanye iitafile ezahluliweyo (nguyennguyen).
Ukulungiswa kuhambelana nokusetyenziswa kwee-hashes ukongeza endaweni yedatha eyiyo, ukunqanda ukubeka yonke idatha kwimemori xa kusenziwa imibuzo emikhulu Ukwahlulahlula kwandise inani leemeko apho izahlulelo zinokususwa okanye zidityaniswe.
Tambien yongeze amandla okusebenzisa amanani aphambili iveliswe ngumyalelo «YENZA IINKCUKACHA»Ukuphucula ukusebenza ngokucwangcisiweyo kwemibuzo iqulethe "OKANYE" amagatya okanye uluhlu lokukhangela olusebenzisa "IN" okanye "ANY".
Ukucoca izalathiso ngexesha lokusebenza VACUUM isantya ngenxa yokuqokelelwa kwenkunkuma kwizalathiso. Ngomgaqo omtsha «EZIQHELEKILEYO»Umphathi unokuchaza inani lemisonto eya kuqalwa ngaxeshanye kwi VACUUM.
Inkxaso eyongeziweyo yokuhlelwa okwandayo, ekuvumela ukuba usebenzise idatha ehlelwe kwinqanaba langaphambili ukukhawulezisa ukuhlela kumanqanaba okugqibela ekusetyenzwa kwesicelo
Ukwenza ulungiso olutsha, umcwangcisi wombuzo unikezela useto » yenza_yokukhulisa_sort ', Ethi yenziwe ngokungagqibekanga.
Yongeze amandla okunciphisa umda wobungakanani bokuphindaphinda, ekuvumela ukuba uqinisekise ngokuzenzekelayo ukugcinwa kokubhalwa emva kwelog (WAL) de kube kufunyenwe zonke iiseva zokulinda ezifumana iimpendulo. Indawo ephindaphindayo ikwathintela iserver ephambili ekususeni imiqolo, enokuthi ikhokelele kwimpixano nokuba iseva yesibini ayi-offline.
De Olunye utshintsho olwahlukileyo yale nguqulo intsha:
- Ipharamitha max_slot_wal_keep_size ngoku inokusetyenziselwa ukunciphisa ubungakanani obukhulu beefayile zeWAL ukunqanda ukuphuma kwesithuba sediski.
- Amathuba okubeka esweni umsebenzi we-DBMS andisiwe: kumyalelo QAPHELA, ukuboniswa kweenkcukacha-manani ezongezelelweyo kusetyenziso lwe-WAL-log kubonelelwe.
- Umyalelo omtsha wongezwa pg_okuqinisekisabackup Ukuqinisekisa ukuthembeka kwee-backups ezenziwe ngumyalelo pg_basebackup.
- Xa usebenza noJSON usebenzisa abaqhubi jsonpath, kuvunyelwe ukusebenzisa umsebenzi ixesha () ukuguqula iifomati zexesha (imitya ye-ISO 8601 kunye neendidi zexesha lePostgreSQL).
- Umsebenzi owakhelweyo wongezwa uhlobo_random_uuid () ukuvelisa iUUID v4.
Inkqubo yokwahlula inikezela ngenkxaso epheleleyo yokuphindaphinda okunengqondo kunye Naphambi kwenqanaba lomqolo. - Umxholo wolwandiso oluthembekileyo luphunyeziwe, olunokufakwa ngabasebenzisi abaqhelekileyo abangenawo amalungelo omlawuli we-DBMS.
- Uluhlu lwezi plugins luchazwe kwangaphambili kwaye lunokwandiswa ngumsebenzisi ophezulu. Iiplagi ezithembakeleyo zibandakanya pgcrypto, tablefunc, hstore, njl.
- Itafile yangaphandle yokujoyina indlela yesikhongozeli sedatha sangaphandle (zithuba_fdw) Ixhasa ukuqinisekiswa okusekwe kwisatifikethi.
Okokugqibela, kuyakhankanywa ukuba uhlaziyo lwesebe elitsha luza kupapashwa iminyaka emihlanu kude kube nguNovemba 2025.
Umthombo: https://www.postgresql.org/