Ngemva konyaka wokuthuthuka, kushicilelwe igatsha elisha elizinzile le-PostgreSQL 15 DBMS. Izibuyekezo zegatsha elisha zizokhishwa phakathi neminyaka emihlanu kuze kube nguNovemba 2027.
Okuqanjiwe okuyinhloko:
- Kwengezwe ukwesekwa komyalo we-SQL othi "MERGE", ofana nenkulumo ethi "FAKA ... ON CONFLICT". I-MERGE ikuvumela ukuthi udale izitatimende ze-SQL ezinemibandela ezihlanganisa ukusebenza kwe-INSERT, UPDATE, kanye nokuthi SUSA kube inkulumo eyodwa. Isibonelo, usebenzisa i-MERGE, ungahlanganisa amatafula amabili ngokufaka amarekhodi angekho futhi ubuyekeze akhona. HLANGANISA I-accounting_yekhasimende ca USEBENZISA imisebenzi_yakamuva t.customer_id = ca.customer_id UMA IFANISIWE BESE UBUYEKEZA ISETHA ibhalansi = ibhalansi + okwenziwayo_inani LAPHO INGAHAMBISANI BESE FAKA (i-id_yekhasimende, ibhalansi) AMABANGA (t.customer_id, Customer_id);
- Ama-algorithms okuhlunga idatha kumemori nakudiski athuthukiswe kakhulu. Ngokuya ngohlobo lwedatha, ukuhlolwa kubonisa ukwanda kwejubane lokuhlunga ukusuka ku-25% ukuya ku-400%.
- Imisebenzi yewindi esebenzisa irowu_number(), isikhundla(), dense_rank() kanye nokubala() isheshisiwe.
- Amathuba wokwenza okufanayo kwemibuzo nenkulumo ethi “KHETHA DISTINCT” sekwenziwe.
- Indlela yokuxhuma amathebula angaphandle Isonga Sedatha Yangaphandle (postgres_fdw) isebenzisa ukusekela kokuzibophezela okuvumelanayo ngaphezu kwekhono elingezwe ngaphambilini lokucubungula izicelo ngokulinganayo kumaseva angaphandle.
- Kwengezwe ikhono lokusebenzisa ama-algorithms e-LZ4 ne-Zstandard (zstd) ukuze iminyanise amalogi omsebenzi we-WAL, okuthi, ngaphansi kwemithwalo ethile yomsebenzi, ngesikhathi esisodwa ithuthukise ukusebenza futhi yonge isikhala sediski. Ukunciphisa isikhathi sokuthola kabusha ngemva kokwehluleka, usekelo lokubuyisela ngokushesha amakhasi avela kulogi ye-WAL yengeziwe.
- Insiza ye-pg_basebackup yengeze ukusekelwa kokucindezelwa ohlangothini lweseva lwamafayela ayisipele kusetshenziswa izindlela ze-gzip, LZ4 noma ze-zstd. Kungenzeka ukusebenzisa amamojula akho ukuze ulondoloze kungobo yomlando, okukuvumela ukuthi wenze ngaphandle kwesidingo sokusebenzisa imiyalo yegobolondo.
- Uchungechunge lwemisebenzi emisha yengezwe ukuze kucutshungulwe izintambo kusetshenziswa izisho ezivamile: regexp_count(), regexp_instr(), regexp_like() kanye ne-regexp_substr().
- Amandla okuhlanganisa izinhlobo zamarange amaningi (“multirange”) lengezwe kumsebenzi othi range_agg().
- Imodi ye-security_invoker eyengeziwe, ekuvumela ukuthi udale ukubuka okusebenza njengomsebenzisi oshaya ucingo esikhundleni somdali wokubuka.
- Ukuze uthole ukuphindaphinda okunengqondo, usekelo lokuhlunga imigqa kanye nezinhlu ezicacisayo zamakholomu sekwenziwe, okuvumela ohlangothini lomthumeli ukuthi akhethe isethi encane yedatha kuthebula ukuze aphindaphinde. Ngaphezu kwalokho, inguqulo entsha yenza ukulawula ukungqubuzana kube lula, isibonelo, manje usuyakwazi ukweqa okwenziwayo okungqubuzanayo futhi ukhubaze ngokuzenzakalelayo ukubhalisa lapho kutholwa iphutha. Ukuphindaphinda okunengqondo kuvumela ukusetshenziswa kwezigaba ezimbili (2PC).
- Ifomethi yelogi entsha yengeziwe - i-jsonlog, egcina ulwazi ngendlela ehlelekile kusetshenziswa ifomethi ye-JSON.
- Umlawuli unamandla okuthumela amalungelo angawodwana kubasebenzisi ukuze aguqule imingcele ethile yokucushwa kweseva ye-PostgreSQL.
- Insiza ye-psql yengeze usekelo lokusesha ulwazi mayelana nezilungiselelo (pg_settings) usebenzisa umyalo "\dconfig".
- Ukusetshenziswa kwememori eyabiwe kuqinisekiswa ukuze kuqoqwe izibalo mayelana nokusebenza kweseva, okwenza kube nokwenzeka ukususa inqubo ehlukile yokuqoqa izibalo kanye nokusetha kabusha isimo kudiski ngezikhathi ezithile.
- Ikhono lokusebenzisa izifunda ze-ICU ezizenzakalelayo “I-ICU Collation” linikeziwe; ngaphambilini, izifunda ze-libc kuphela ezazingasetshenziswa njengendawo ezenzakalelayo.
- Kuhlongoziwe isandiso esakhelwe ngaphakathi esithi pg_walinspect, esikuvumela ukuthi uhlole okuqukethwe kwamafayela ngamalogi we-WAL usebenzisa imibuzo ye-SQL.
- Ku-schema somphakathi, bonke abasebenzisi, ngaphandle komnikazi wesizindalwazi, babe negunya labo lokusebenzisa umyalo we-CREATE ochithiwe.
- Usekelo lwe-Python 2 lususiwe ku-PL/Python. Imodi yesipele ekhethekile ephelelwe yisikhathi isusiwe.
Ukwengeza: Kusukela ku-19: 00 kuya ku-20: 00 (MSK) kuzoba ne-webinar exoxa ngezinguquko zenguqulo entsha noPavel Luzanov (Postgres Professional). Kulabo abangakwazi ukujoyina ukusakaza, ukurekhodwa kombiko ka-Pavel kaJuni "PostgreSQL 15: MERGE nokuningi" ku-PGConf.Russia kuvuliwe.
Source: opennet.ru