Ngemuva cishe konyaka wentuthuko ukukhishwa kwenguqulo entsha yegatsha elizinzile kwamenyezelwa we-DBMS I-PostgreSQL 14 izibuyekezo zawo zegatsha elisha ezizoshicilelwa iminyaka emihlanu kuze kube nguNovemba 2026.
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 14?
Kule nguqulo entsha uhlobo lwencazelo yobubanzi lunwetshiwe ngezinhlobo ezintsha "zobubanzi obuningi" lokho vumela chaza uhlu olu-odiwe lwamabanga wamanani angagqagqelani. Ngokungeziwe ohlotsheni lobubanzi obukhona ngalunye, uhlobo lwalo lobubanzi obuningi luyaphakanyiswa. Ukusetshenziswa kwezinhlobo ezintsha kwenza lula ukwakheka kwemibuzo elawula ukulandelana okuyinkimbinkimbi kwamabanga.
Futhi amakhono anwetshiwe ngokulungiselela okusatshalalisiwe okubandakanya amaseva amaningi we-PostgreSQL. Ekusebenziseni ukuphindaphindeka okunengqondo, bekukwazi ukusakaza ukuqhutshwa okuqhubekayo, okungahle ngcono kakhulu ukusebenza kokuziphindaphinda kokuthengiselana okukhulu. Ngaphezu kwalokho, ukucaciswa okunengqondo kwedatha efika ngesikhathi sokuphindaphindeka okunengqondo kulungiselelwe.
Ngokwengeziwe kungezwe ukusekelwa kokusebenza ohlangothini lweklayenti (Kusetshenziswe ku-libpq) Izicelo zokudlulisa imodi yokudlulisa ukusheshisa kakhulu izimo zedathabheyisi elihlotshaniswa nokwenziwa kwenani elikhulu lemisebenzi emincane yokubhala (INSERT / UPDATE / DELETE) ngenxa yokuthumela isicelo esilandelayo ngaphandle kokulinda umphumela walokhu okungenhla . Imodi isiza nokusheshisa umsebenzi ekuxhumaneni nokubambezeleka okude ekulethweni kwephakeji.
Indlela yangaphandle yesiqukathi sedatha (okuthunyelwe_fdw) Ukuxhuma amatafula angaphandle kungeze ukusekelwa kokucutshungulwa kombuzo okufanayo, okwamanje kusebenza kuphela lapho uxhuma kwamanye amaseva we-PostgreSQL. Thumela ama-postgres_fdw futhi ingeza ukusekelwa kokwengeza idatha kumatafula angaphandle kumodi ye-batch kanye nekhono lokungenisa amatafula ahlukanisiwe ngokucacisa inkomba ethi "IMPORT FOREIGN SCHEMA".
Futhi, ukwenziwa okuhle kwenziwe ekuqalisweni kokusebenza kwe-VACUUM (ukuqoqwa kukadoti nokupakisha isitoreji sediski), ungeze "imodi ephuthumayo" ukweqa ukusebenza okungabalulekile kwe-wrapper uma kudalwa izimo ezisongelayo ze-ID yomsebenzi futhi zehliswa ngaphezulu lapho kucubungulwa izinkomba ze-B-Tree. Ukusheshiswa kokusebenza kwe- "ANALYZE", okuqoqa izibalo ngokusebenza kwedathabheyisi, kusheshiswe kakhulu.
Ngakolunye uhlangothi, kuphinde kuqokonyiswe lokho Amathuluzi anwetshiwe ukuqapha ukusebenza kwe-DBMS, kahle se kungezwe ukubuka ukulandelela inqubekela phambili yomyalo "COPY", izibalo mayelana nokuphindaphindeka kwezikhala nomsebenzi we-WAL transaction log.
KuPostgreSQL 14 singakuthola futhi lokho ingeze amandla okwenza ngokwezifiso indlela yokuminyanisa esetshenziswe ohlelweni lwe-TOAST, enesibopho sokugcina idatha enkulu njengamabhulokhi wombhalo noma imininingwane yejometri. Ngaphezu kwendlela yokuminyanisa ye-pglz, i-TOAST manje isingasebenzisa i-algorithm ye-LZ4.
Kungeziwe Ukulungiselelwa kokuhlelwa kombuzo ukuthuthukisa ukucubungulwa kombuzo okufanayo nokwenza ngcono ukusebenza kokwenziwa ngasikhathi sinye kwamarekhodi wokuskena okulandelanayo, ukwenziwa kwemibuzo ngokufana ku-PL / pgSQL kusetshenziswa umyalo othi "BUYISA UMBUZO" kanye nokwenziwa kwemibuzo ngokufana ku- "REFRESH MATERIALIZED VIEW".
Kwezinye izinguquko okugqamile:
- Ukusekelwa okungeziwe kokulondolozwa kwesikhashana kufakiwe ukuze kuthuthukiswe ukusebenza kwamajoyini ayindilinga ayizidleke (joyina).
- Ukulungiswa kwenzelwe ukuthuthukisa ukusebenza kwezinhlelo ezilayishwe kakhulu eziphethe inani elikhulu lokuxhuma. Kokunye ukuhlolwa, ukusebenza kuphindwe kabili.
- Ukusebenza kwezinkomba zomuthi we-B sekuthuthukisiwe futhi inkinga ngokukhula kwezinkomba lapho amatafula evuselelwa kaningi isixazululiwe.
- Izibalo manje ezinwetshiwe zingasetshenziselwa ukwengeza izinkulumo nezinhlobo zokukhuphuka zingasetshenziselwa ukwengeza imisebenzi yewindows.
Ekugcineni sUma unentshisekelo yokwazi okwengeziwe ngakho, ungabheka imininingwane Kulesi sixhumanisi esilandelayo.