I-ProHoster > Блог > izindaba ze-inthanethi > Ukukhishwa kwe-PostgreSQL 13 DBMS

Ukukhishwa kwe-PostgreSQL 13 DBMS

Ngemva konyaka wentuthuko eshicilelwe igatsha elisha elizinzile le-DBMS I-PostgreSQL 13. Izibuyekezo zegatsha elisha izophuma iminyaka emihlanu kuze kube nguNovemba 2025.

main emisha:

  • Kwenziwa ukuphindaphinda amarekhodi kuzinkomba ze-B-tree, okwenze kwaba nokwenzeka ukuthuthukisa ukusebenza kombuzo nokunciphisa ukusetshenziswa kwesikhala sediski lapho ukhomba amarekhodi anedatha eyimpinda. Ukuphindaphinda kwenziwa ngokwethula ngezikhathi ezithile isibambi esihlanganisa amaqembu ama-tuples aphindayo futhi simiselele izimpinda ngezixhumanisi zekhophi eyodwa egciniwe.
  • Ukusebenza okuthuthukisiwe kwemibuzo esetshenziswayo hlanganisa imisebenzi, amasethi aqoqwe (AMASETHI EQEMBU) noma ehlukanisiwe (ahlukaniswe) amatafula. Ukuthuthukisa kuhilela ukusebenzisa ama-hashe esikhundleni sedatha yangempela lapho kuhlanganiswa, okugwema ukubeka yonke idatha kumemori lapho kucutshungulwa imibuzo emikhulu. Uma kuhlukaniswa, inani lezimo lapho ukuhlukaniswa kungalahlwa noma kuhlanganiswe kunwetshiwe.
  • Kwengezwe ikhono lokusebenzisa izibalo eziphambiliidalwe ngokusebenzisa umyalo othi DALA IZIBALO ukuze uthuthukise ukusebenza kahle kweshejuli equkethe NOMA izimo noma uhlu lokusesha usebenzisa IN noma YILUPHI izinkulumo.
  • Ukuhlanzwa kwezinkomba ngesikhathi sokusebenza kusheshisiwe I-VACUUM ngokufanisa ukuqoqwa kukadoti ngezinkomba. Esebenzisa ipharamitha entsha ethi "PARALLEL", umlawuli angakwazi ukunquma inombolo yochungechunge oluzosebenza kanye kanye ku-VACUUM. Kwengezwe amandla okuqalisa ukusebenza kwe-VACUUM okuzenzakalelayo ngemva kokufakwa kwedatha.
  • Ukwesekwa okwengeziwe kokuhlunga okungeziwe, okukuvumela ukuthi usebenzise idatha ehlungwe esigabeni sangaphambilini ukuze usheshise ukuhlunga ezigabeni ezilandelayo zokucutshungulwa kombuzo. Ukuze unike amandla ukulungiselelwa okusha kusihleli sombuzo, kukhona ukulungiselelwa “vumela_incremental_sort", enikwe amandla ngokuzenzakalela.
  • Kwengezwe ikhono lokukhawulela usayizi ukuphindaphinda Slots, okukuvumela ukuthi uqinisekise ngokuzenzakalelayo ukulondolozwa kwamasegimenti elogi evilaphayo (WAL) aze atholwe yiwo wonke amaseva asekelayo athola ikhophi. Izikhala zokuphindaphinda futhi zivimbela iseva eyinhloko ekususeni imigqa engabangela ukungqubuzana, ngisho noma iseva eyisipele ingaxhunyiwe ku-inthanethi. Ukusebenzisa ipharamitha max_slot_wal_keep_size Manje ungakhawulela ubukhulu bosayizi wamafayela e-WAL ukuze uvimbele ukuphelelwa isikhala sediski.
  • Amandla okuqapha umsebenzi we-DBMS anwetshiwe: umyalo we-EXPLAIN unikeza ukuboniswa kwezibalo ezengeziwe ngokusetshenziswa kwelogi ye-WAL; V pg_basebackup inikeze ithuba lokulandelela isimo sezipele eziqhubekayo; Umyalo we-ANALYZE unikeza inkomba yenqubekelaphambili yomsebenzi.
  • Umyalo omusha wengeziwe pg_verifybackup ukuhlola ubuqotho bezipele ezidalwe umyalo we-pg_basebackup.
  • Lapho usebenza ne-JSON usebenzisa ama-opharetha jsonpath Ivumela umsebenzi we-datetime() ukuthi usetshenziselwe ukuguqula amafomethi wesikhathi (amayunithi ezinhlamvu e-ISO 8601 nezinhlobo zesikhathi ze-PostgreSQL zomdabu). Isibonelo, ungasebenzisa ukwakhiwa kwe-"jsonb_path_query('["2015-8-1", "2015-08-12"]', '$[*] ? (@.datetime() < "2015-08-2" ".datetime ())')" kanye "jsonb_path_query_array('["12:30", "18:40"]', '$[*].datetime("HH24:MI")')".
  • Kwengezwe umsebenzi owakhelwe ngaphakathi gen_random_uuid () ukukhiqiza i-UUID v4.
  • Isistimu yokuhlukanisa ihlinzeka ngokusekela okugcwele kokuphindaphinda okunengqondo kanye nalezo ezicaciswe yinkulumo ethi "PHAMBI".
    izicupha ezisebenza ezingeni lomugqa.

  • Синтаксис «LANDA KUQALA" manje ivumela ukusetshenziswa kwenkulumo ethi "NGEZIBOPHO" ukubuyisela imigqa eyengeziwe esemsileni wesethi yomphumela etholwe ngemva kokufaka "ORDER BY".
  • Kusetshenziswe umqondo wezengezo ezinokwethenjelwa (“isandiso esethembekile"), engafakwa abasebenzisi abajwayelekile abangenawo amalungelo omlawuli we-DBMS. Uhlu lwezengezo ezinjalo luchazwe ngaphambilini futhi lunganwetshwa umsebenzisi omkhulu. Izengezo ezinokwethenjelwa zihlanganisa pgcrypto, tablefunc, hstore nokunye okunjalo.
  • Indlela yokuxhuma amathebula angaphandle Isisonga Sedatha Yangaphandle (postgres_fdw) isebenzisa usekelo lokuqinisekisa okusekelwe kusitifiketi. Uma usebenzisa ukuqinisekiswa kwe-SCRAM, amaklayenti avunyelwe ukucela "ukubophezela kwesiteshi"(ukubopha isiteshi).

Source: opennet.ru

Engeza amazwana