I-PostgreSQL iwumthombo ovulekile wohlelo lokuphathwa kwesizindalwazi esigxile entweni.
Ngemuva konyaka wentuthuko ukukhishwa kwegatsha elisha elizinzile le-DBMS PostgreSQL 15 limenyezelwe, Lokhu kukhishwa kufaka phakathi izithuthukisi eziningi, okuhlanganisa amandla amasha okucindezela asiza ngokugcina idatha nokwenza ikhophi yasenqolobaneni, ukuthuthukiswa kokuhlelwa kwedatha ukuze kuhlolwe ngokushesha, kanye namandla amasha okugawula kanye ne-SQL.
Kule nguqulo entsha eyethulwa, umyalo we-SQL "MERGE" ugqanyisiwe, lokho ikuvumela ukuthi udale izitatimende ze-SQL ezinemibandela okuhlanganisa okuthi FAKA, UKUBUYEKEZA, kanye nokuthi SUSA imisebenzi esitatimendeni esisodwa. Ngokwesibonelo, UKUHLANGANISA kungasetshenziswa ukuhlanganisa amathebula amabili ngokufaka amarekhodi angekho nokubuyekeza akhona kakade.
Umyalo ivumela ukuhlanganiswa kwetafula futhi yenza i-PostgreSQL ihambisane kakhulu nge-SQL Server-based relational management system, okuhlanganisa i-Microsoft SQL Server kanye neseva yesizindalwazi esihlobene se-SAP ASE, kanye nanoma yiziphi ezinye ezisekela i-Transact-SQL suite yezandiso zezinhlelo.
Olunye ushintsho olugqamayo kule nguqulo entsha kuma-algorithms okuhlunga idatha kumemori nakudiski athuthukiswe kakhulu. Ngokuya ngohlobo lwedatha ekuhlolweni, kunokwenyuka kwesivinini sokuhlunga kusuka ku-25% kuya ku-400%.
Ukuze uthole ukuphindaphinda okunengqondo, ukusekelwa kokuhlunga imigqa kanye nezinhlu ezicacisayo zamakholomu kuyasetshenziswa, okuvumela, ohlangothini lomthumeli, ukukhetha isethi engaphansi yedatha yokuphindaphinda kwethebula. Ngaphezu kwalokho, inguqulo entsha yenze lula ukulawula ukungqubuzana, isibonelo ikhono lokweqa okwenziwayo okungqubuzanayo nokunqamula ngokuzenzakalelayo ukubhalisa lapho kutholwa iphutha. Ukuphindaphinda okunengqondo kuvumela ukusetshenziswa kwezigaba ezimbili (2PCs).
Indlela yokuxhuma amathebula angaphandle Isiqukathi sedatha yangaphandle (postgres_fdw) isebenzisa ukusekelwa kokuzibophezela okungavumelaniyo ngaphezu kwekhono elingezwe ngaphambilini lokucubungula izicelo kumaseva angaphandle ngokuhambisanayo.
Kwengezwe amandla okusebenzisa i-LZ4 ne-Zstandard algorithms (zstd) ukuze iminyanise amalogi omsebenzi we-WAL, okuthi, ngaphansi kwemithwalo ethile yomsebenzi, ngesikhathi esisodwa ithuthukise ukusebenza futhi ilondoloze isikhala sediski, futhi yengeze usekelo lokubuyisela ngokushesha amakhasi avela kulogu yokwenziwayo. I-WAL yokunciphisa isikhathi sokwehluleka ukutholwa.
Kubuye kuqhakanjiswe lokho ingezwe kusisetshenziswa se-pg_basebackup la ukwesekwa kokucindezela amafayela ayisipele ohlangothini lweseva usebenzisa gzip, LZ4, noma izindlela ze-zstd. Ikhono lokusebenzisa amamojula wakho wokufaka kungobo yomlando linikeziwe, elikuvumela ukuthi ukhiphe isidingo sokusebenzisa imiyalo yegobolondo.
Ngaphezu kwalokho, manje ku-PostgreSQL 15 ukusetshenziswa kwememori okwabiwe kwaqinisekiswa ukuze kuqoqwe izibalo zokusebenza kweseva, okwenze kwaba nokwenzeka ukususa inqubo ehlukile yokuqoqa izibalo futhi ngezikhathi ezithile iguqule isimo kudiski.
Kwezinye izinguquko ezigqame kusuka enguqulweni entsha:
- Kwengezwe inani lemisebenzi emisha ukuze kucutshungulwe izintambo kusetshenziswa izinkulumo ezivamile: regexp_count(), regexp_instr(), regexp_like(), kanye ne-regexp_substr().
- Kwengezwe ikhono lokwengeza izinhlobo zebanga eliningi ("multi-range") kumsebenzi othi range_agg().
Kwengezwe imodi ye-security_invoker ukuvumela ukudalwa kokubuka okuhambisana namalungelo omsebenzisi ocelayo, kunomdali wokubuka. - Ifomethi yelogi entsha yengeziwe: i-jsonlog, elondoloza ulwazi ngendlela ehlelekile kusetshenziswa ifomethi ye-JSON.
- Umlawuli unamandla okuthumela amalungelo angawodwana kubasebenzisi ukuze aguqule imingcele ethile yokucushwa kweseva ye-PostgreSQL.
- Usekelo lwengeziwe ukuze insiza ye-psql ibheke ulwazi mayelana nezilungiselelo (pg_settings) kusetshenziswa umyalo "\dconfig".
- Kuphakanyiswe isandiso esakhelwe ngaphakathi se-pg_walinspect esikuvumela ukuthi uhlole okuqukethwe kwamafayela ngamarekhodi we-WAL usebenzisa imibuzo ye-SQL.
- Kususwe ukwesekwa kwePython 2 ku-PL/Python
- Kukhishwe imodi "yokwenza isipele okukhethekile".
- Amathuba okwenziwa kwemibuzo ngokuhambisana namagama athi "KHETHA DISTINCT" kuyasetshenziswa.
Ekugcineni kufanelekile ukusho lokho izibuyekezo zegatsha elisha zizokhishwa iminyaka emihlanu kuze kube nguNovemba 2027. Uma ungathanda ukwazi okwengeziwe ngayo, ungathintana nemininingwane ku isixhumanisi esilandelayo.