I-PostgreSQL, ebizwa nangokuthi i-Postgres, iwumthombo ovulekile, uhlelo lokuphathwa kwesizindalwazi esigxile ezintweni.
Ngemuva kwezinyanga eziyi-11 zentuthuko, Ukwethulwa kwenguqulo entsha ye-PostgreSQL 16 kumenyezelwe, efika njengegatsha elisha elizinzile le-DBMS futhi lapho izibuyekezo zeminyaka emihlanu, kuze kube nguNovemba 2028, Ngaphezu kwalokho, iphawula ukuphela kwegatsha le-PostgreSQL 11.x, okuyigatsha lamanje elidala kakhulu elinokusekelwa, elizophela ngoNovemba 9.
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.
Izici ezintsha eziyinhloko zePostgreSQL 16
Kule nguqulo entsha ye-PostgreSQL 16 eyethulwa, kuyacaca ukuthi Amathuluzi okulawula ukufinyelela okuphindaphinda okunengqondo anwetshiwe. Isibonelo, umsebenzi omusha ochazwe ngaphambilini othi “pg_create_subscription” wengeziwe, okuvumela ukuthi unikeze abasebenzisi ilungelo lokudala ukubhalisa okusha.
Kungeziwe ukwesekwa kokulinganisa umthwalo ohlangothini lwamakhasimende abasebenzisa umtapo wezincwadi we-libpq ojwayelekile, ukulinganisa kuvumela iklayenti ukuthi lixhume kubasingathi abahlukahlukene, abangakhethwa ngendlela ethile noma engahleliwe. Uma umsingathi engatholakali, kuzanywa ukuxhuma kwenye iseva. Uma uxhumano selusungulwe, izicelo ngaphakathi kweseshini zithunyelwa kuseva ekhethiwe.
Ngaphandle kwakho ukulungiselelwa kwenziwe futhi umsebenzi wohlelo lwemibuzo uthuthukisiwe, njengoba ukufana kwemisebenzi yokujoyina ithebula » NGOKUPHELELE » futhi » UKUJOYINA OKUFANELE » kunikezwa
Ku-PostgreSQL 16, singakuthola futhi lokho ukwesekwa okunwetshiwe kwezakhiwo zasendaweni "ze-Collation"., okuvumela ukusungula imithetho yokuhlukanisa nezindlela zokuqhathanisa kucatshangelwa incazelo yabalingiswa. Ngokuzenzakalelayo, manje isihlanganiswa nezindawo ze-ICU esikhundleni sendawo ye-libc.
Sekuyi ukwenza ngcono ukuphindaphinda okunengqondo, kusukela ikhono lokusebenzisa amaprosesa asebenza kanyekanye, ngaphezu kokwengeza ikhono lokusebenzisa izinkomba ze-B-tree kumathebula angenabo okhiye abayinhloko, okuqeda isidingo sokuskena okulandelanayo lapho kuseshwa amarekhodi futhi kuphinde kwasheshisa ukuvumelanisa kokuqala kwamanye amathebula ngefomethi kanambambili.
Okunye ukuthuthukiswa okutholwe indlela yokuphindaphinda okunengqondo yilokho manje ivumela ukudlulisa izinguquko ezenziwe kusizindalwazi Lapho wengeza, ususa, noma ubuyekeza amarekhodi kwenye iseva, iye yandiswa nekhono lokuphindaphinda izinguquko ezivela kuseva eyisipele.
Kungezwe futhi ukusekelwa kokuphindaphinda kwetafula okunezinhlangothi ezimbili, okuvumela izinguquko kumathebula amabili eziphakelini ezihlukene ukuthi zivumelaniswe. Amandla okuphindaphinda angezwe ku-PostgreSQL 16 akuvumela ukuthi udale ukulungiselelwa ngamaseva asebenzayo amaningi (imodi esebenzayo), lapho ungenza khona kanyekanye ukusebenza kwe-INSERT, UPDATE, DELETE.
Of ezinye izinguquko okugqamile:
- Kuthuthukiswe ukusetshenziswa kwemisebenzi ye-"RIGHT JOIN" kanye ne-"OUTER JOIN" ukuze kutholwe imigqa engekho kuthebula elihlanganisiwe ("anti-join").
- Ukusebenza okuthuthukisiwe kohlelo lokuthuthukisa lwemibuzo esebenzisa imisebenzi ehlanganisiwe ngokuhlanganiswa nezigatshana ze-DISTINCT noma ORDER BY.
- Ukuhlunga okukhuphukayo kusetshenziselwa ukusheshisa imibuzo ethi KHETHA DISTINCT.
Isu lokusebenza kwe-VACUUM lenziwe ngcono ukuze kuncishiswe inani lezimo ezidinga ukukhiywa kwetafula lonke. - Kuzakhiwo ze-x86 ne-ARM, imiyalelo ye-vector processor (i-SIMD) isetshenziswa ukuze kusheshiswe ukucubungula amayunithi ezinhlamvu ze-ASCII, ukusebenza kudatha ye-JSON, nokwenza ukuhlola kwamalungu afanayo kanye nokuthengiselana okuncane.
- Imojula ethi “auto_explain” manje ihlanganisa ukusekelwa kwamanani okugawula adluliselwe emibuzweni enepharamitha.
- Kuthuthukiswe ukunemba kwe-algorithm yokulandela isicelo esetshenziswe ku-pg_stat_statements kanye nokubukwa kwe-pg_stat_activity.
- Amandla okuqapha ukusebenza kwe-DBMS anwetshiwe. Kwengezwe ukubuka kwesevisi » pg_stat_io » ngezibalo ezibonisa umthwalo ohlelweni lwe-I/O ngama-backend ahlukahlukene (isisebenzi sangemuva, i-autovacuum, njll.) nezinto.
- Inkambu entsha yengeziwe ekubukeni kwesevisi » pg_stat_all_tables » ngolwazi mayelana nesikhathi sokuskena kokugcina kwethebula noma inkomba.
ekugcineni uma ukhona unentshisekelo yokwazi okwengeziwe ngayo, ungabheka imininingwane kufayela le- isixhumanisi esilandelayo.