Njengoba bekulokhu kunjalo minyaka yonke phakathi kukaSepthemba no-Okthoba, ukukhishwa kwenguqulo entsha ye-PostgreSQL 17 kumenyezelwe , futhi njengakuzo zonke izinguqulo zangaphambilini, okubalulekile kusalokhu kuthuthukisa ukusebenza kanye nokwenza ngcono izinsiza, ikakhulukazi emisebenzini efana ne-VACUUM, i-I/O kanye nemibuzo, kuyilapho isici esisha esibaluleke kakhulu salokhu kukhishwa kungukwenza isipele ngokuqhubekayo.
Kubasebenzisi bebhizinisi, isibuyekezo siletha inqwaba yokuthuthukiswa okwenza lula ukuphathwa kwesizindalwazi nokusetshenziswa. Nakuba i-PostgreSQL ngokomlando ibiyisizindalwazi esihlobene, le nguqulo yandisa ukuhlanganiswa kwayo nokusebenza okuthuthukile kokusebenza nemibhalo ye-JSON, isici esivame ukuhlotshaniswa ne-MongoDB Atlas.
Yini entsha ku-PostgreSQL 17
Kule nguqulo entsha ye-PostgreSQL 17, isakhiwo esisha sedatha sethulwe ekusebenzeni kwe-VACUUM, okunciphisa ukusetshenziswa kwememori izikhathi ezifika kwezingu-20, okuvumela le misebenzi ukuthi isheshe futhi isebenze kahle ngokwezinsiza ezabiwe.
Ngokuphathelene nokuthuthukiswa kokusebenza, ukuphathwa kwerejista yokubhala (i-WAL) kuye kwenziwa ngcono, kwafinyelela ukusebenza kokubhala okuphindwe kabili ezinhlelweni ezinemibuzo eminingi ngesikhathi esisodwa. Kuphakanyiswe isikhombimsebenzisi se-I/O sokusakaza ukuze kuthuthukiswe usesho olulandelanayo kanye nezibuyekezo zezibalo ngemuva kokusebenza kwe-ANALYZE.
Ngaphezu kwalokho, kuthuthukiswe imibuzo enezigaba "ze-IN" lapho kusetshenziswa izinkomba ze-B-tree, kanye nokwakhiwa okuhambisanayo kwezinkomba ze-BRIN, ukwenziwa ngcono kokuhlolwa kwe-"NOT NULL", kanye nokusheshiswa kokucutshungulwa kwezinkulumo zethebula ezivamile (ama-CTE). Ukuze kubalwe ngokujulile, imiyalelo ye-SIMD, njenge-AVX-512, ifakiwe ukusheshisa imisebenzi efana nomsebenzi we-`bit_count`.
Enye into entsha egqamayo yile izici ezintsha ze-JSON, kusukela Abasebenzisi manje bangabuza izinhlobo zedatha ye-JSON besebenzisa imiyalo ejwayelekile ye-SQL. Lokhu kungenzeka ngenxa yokusebenza kwetafula elisha json, eguqula idatha ye-JSON ibe isakhiwo sethebula. Ukusuka lapho, abasebenzisi bangenza imibuzo besebenzisa isigatshana FROM ku-SQL, okuvumela idatha ukuthi ibuyiselwe ngefomethi ehlobene. Kwengezwe umsebenzi othi `JSON_TABLE` ukuze kuguqulwe idatha ye-JSON ibe amathebula e-PostgreSQL ajwayelekile.
Okunye okuphawulekayo ukusebenza okusha kokusekelayo okukhuphukayo ku-PostgreSQL 17, okukuvumela ukuthi wenze isipele kuphela izinguquko ezenziwe kusukela ekusekeleni okugcwele noma okukhuphukayo kokugcina , okwenza ngcono ukusetshenziswa kwe-bandwidth futhi kunciphise izidingo zesitoreji. Ngenkathi i-PostgreSQL isivele inikeza izixazululo ezifana ne-WAL Archiving, ephinde yakopisha i-Write-Ahead Log (WAL) ukuze igcine izingxenye ezidingekayo zedathabheyisi, inguqulo 17 yethula, okokuqala, indlela yemvelo yokwenza izipele ezikhuphukayo. Lolu hlelo alugcini nje ngokunciphisa ukuphazamiseka kokusebenza ngokuba nomthelela omncane ekusebenzeni, kodwa futhi lunciphisa kakhulu izikhathi zokubuyisa—isici esibalulekile, njengoba ukubuyisela izipele kuvame ukuba inqubo ehamba kancane futhi ekhungathekisayo kubasebenzisi.
Injini engazibandakanyi neplatifomu yasungulwa ukucubungula izakhiwo zendawo, okwenza kube lula ukuhlunga imiphumela yombuzo njalo. Le njini ibheka izici ezifana nokuba khona kwezinhlamvu ezikhethekile kanye nokuzwela kwamacala lapho kuhlungwa amanani. Indlela yokuphindaphinda okunengqondo manje yenza inqubo yokuthuthukisa isizindalwazi ibe lula, isuse isidingo sokususa izikhala zokuphindaphinda okunengqondo noma ukuvumelanisa kabusha idatha lapho kuthuthelwa enguqulweni entsha.
Ezinye izinguquko eziphawulekayo zifaka :
- Ukukhipha amayunithi ezinhlamvu amade ngomyalo othi `COPY` kusheshiswe izikhathi ezingafika kwezimbili.
- Ukukopisha okulungiselelwe uma umbhalo wekhodi womthombo nendawo oya kuyo ufana.
- Inketho ethi `ON_ERROR` yengeziwe ukuze kuvunyelwe ukungenisa ukuthi kuqhubeke naphezu kwamaphutha okufaka idatha.
- Kwengezwe ikhono lokusebenzisa amakholomu anezihlonzi ezihlukile kumathebula ahlukanisiwe.
- Kusetshenziswe isici sokuhluleka ukushintshela kuseva eyisipele ekucushweni okubekezelela iphutha.
- Kwengezwe insiza entsha ye-pg_createsubscriber ukuze kuguqulwe i-replica ebonakalayo ibe ikhophi enengqondo.
- Kwethulwe inketho ethi "sslnegotiation" yokuxoxisana nokuxhumeka okuvikelekile kwe-TLS kusetshenziswa isandiso se-ALPN TLS.
- Kwengezwe indima echazwe ngaphambilini pg_maintain, enikeza abasebenzisi ilungelo lokwenza imisebenzi ehlobene nokugcinwa kwe-DBMS
Okokugcina, uma unesithakazelo sokufunda okwengeziwe, ungathola imininingwane kusixhumanisi esilandelayo.