I-PostgreSQL yinkqubo yolawulo lwesiseko sedatha ejoliswe kwinto evulelekileyo.
Emva konyaka wophuhliso ukukhutshwa kwesebe elitsha elizinzileyo le-DBMS PostgreSQL 15 yabhengezwa, Olu khululo lubandakanya inani lophuculo, kubandakanywa amandla amatsha oxinzelelo olunceda ukugcinwa kwedatha kunye ne-backup, ukuphuculwa kokuhlelwa kwedatha ukukhangela ngokukhawuleza, kunye nokugawulwa okutsha kunye nezakhono zeSQL.
Kule nguqulelo intsha ikhoyo, Umyalelo weSQL "MERGE" ubonisiwe, que ikuvumela ukuba wenze iingxelo zeSQL ezinemiqathango ezidibanisa INSERT, UHLAZIYO, kunye ne-CIMA imisebenzi kwingxelo enye. Umzekelo, ukudibanisa kungasetyenziselwa ukudibanisa iitafile ezimbini ngokufaka iirekhodi ezingekhoyo kunye nokuhlaziya esele zikhona.
Umyalelo ivumela ukudityaniswa kwetafile kwaye yenza iPostgreSQL ihambelane ngakumbi kunye ne-SQL Server-based relational management systems, kuquka i-Microsoft SQL Server kunye ne-SAP ASE yeseva yedatha enxulumeneyo, kunye nazo naziphi na ezinye ezixhasa i-Transact-SQL suite yolwandiso lweprogramu.
Olunye utshintsho olugqamayo kule nguqulelo intsha kwii-algorithms zokuhlela idatha kwimemori nakwidiski ziphuculwe kakhulu. Ngokuxhomekeke kuhlobo lwedatha kwiimvavanyo, kukho ukwanda kwesantya sokuhlela ukusuka kwi-25% ukuya kwi-400%.
Ukuphindaphinda okunengqiqo, inkxaso yokucoca imiqolo kunye noluhlu olubalula lwezintlu luyaphunyezwa, evumela, kwicala lomthumeli, ukukhetha iseti esezantsi yedatha yophindaphindo lwetafile. Ukongeza, inguqulelo entsha yenze lula ulawulo lweengxabano, umzekelo ukukwazi ukutsiba iintengiselwano eziphikisanayo kunye nokuqhawula ngokuzenzekelayo umrhumo xa kubonwa impazamo. Ukuphindaphinda okunengqondo kuvumela ukusetyenziswa kweendlela ezimbini (2PCs).
Indlela yokudibanisa iitafile zangaphandle Isikhongozeli sedatha sangaphandle (postgres_fdw) iphumeza inkxaso yee-asynchronous commits ukongeza kwisakhono esongeziweyo sangaphambili sokuqhuba izicelo kwiiseva zangaphandle ngokulandelelanayo.
Ukongeza amandla okusebenzisa i-LZ4 kunye ne-algorithms ye-Zstandard (zstd) ukucinezela iilogi zentengiselwano ze-WAL, ezithi, phantsi komthwalo othile womsebenzi, ngaxeshanye ziphucule ukusebenza kunye nokugcina indawo yediski, kunye nenkxaso eyongeziweyo yokubuyiswa ngokukhawuleza kwamaphepha avela kwilog yentengiselwano.
Kuyacaciswa ukuba ifakwe kwi pg_basebackup into eluncedo la inkxaso yokucinezela iifayile zogcino kwicala lomncedisi usebenzisa gzip, LZ4, okanye iindlela ze-zstd. Ukukwazi ukusebenzisa iimodyuli zakho kugcino kunikezelwa, okukuvumela ukuba unikezele ngesidingo sokusebenzisa imiyalelo yeqokobhe.
Ukongeza kuloo nto, ngoku kwiPostgreSQL 15 ukusetyenziswa kwememori okwabelwanayo kwaqinisekiswa kuqokelelo lweenkcukacha-manani ekusebenzeni komncedisi, okwenze ukuba kube nokwenzeka ukulahla inkqubo eyahlukileyo yokuqokelela izibalo kunye nokugungxulwa ngamaxesha athile kwidisk.
Olunye utshintsho olwahlukileyo kuhlobo olutsha:
- Kongezwe inani lemisebenzi emitsha ukucubungula imitya kusetyenziswa iintetho eziqhelekileyo: regexp_count (), regexp_instr (), regexp_like (), kunye regexp_substr ().
- Kongezwe ukukwazi ukongeza iindidi ezininzi zoluhlu ("iintlobo ezininzi") kuluhlu_agg () umsebenzi.
Yongeza imowudi ye-invoker ukuvumela ukuyilwa kweembono ezihamba namalungelo omsebenzisi obizayo, kunokuba ngumyili wembono. - Ifomati entsha yelog yongezwe: jsonlog, egcina ulwazi ngendlela ecwangcisiweyo kusetyenziswa ifomati ye-JSON.
- Umlawuli unamandla okunikezela ngamalungelo omntu ngamnye kubasebenzisi ukuba batshintshe iiparamitha ezithile zokumisela iseva ye-PostgreSQL.
- Inkxaso yongezwe kwi-psql utility ukujonga ulwazi malunga nezicwangciso (pg_settings) usebenzisa "\dconfig" umyalelo.
- Ulwandiso olwakhiweyo lwe-pg_walinspect lucetyiwe olukuvumela ukuba uhlole imixholo yeefayile ngeerekhodi ze-WAL usebenzisa imibuzo ye-SQL.
- Isusiwe iPython 2 inkxaso kwi-PL/Python
- Kususwe imo "yegcisa olukhethekileyo".
- Ukwenzeka kokusetyenziswa ngokuhambelanayo kwemibuzo kunye nebinzana elithi "KHETHA I-DIISTINCT" iphunyeziwe.
Ekugqibeleni kufanelekile ukukhankanya oko uhlaziyo lwesebe elitsha luya kukhutshwa iminyaka emihlanu de kube ngoNovemba 2027. Ukuba unomdla wokwazi ngakumbi ngayo, ungajonga iinkcukacha kwi ukulandela ikhonkco.