Pulogalamu ya ProHoster > Blog > nkhani zapaintaneti > PostgreSQL 13 DBMS kutulutsidwa

PostgreSQL 13 DBMS kutulutsidwa

Pambuyo pa chaka cha chitukuko losindikizidwa nthambi yatsopano yokhazikika ya DBMS PostgreSQL 13. Zosintha za nthambi yatsopano adzatuluka kwa zaka zisanu mpaka Novembala 2025.

waukulu zatsopano:

  • Zakhazikitsidwa kuchotsera zolemba m'mindandanda yamitengo ya B, zomwe zidapangitsa kuti zitheke kuwongolera magwiridwe antchito ndikuchepetsa kugwiritsa ntchito malo a disk polemba zolemba zomwe zili ndi data yobwereza. Kudulira kumachitika kudzera pakukhazikitsa kwanthawi ndi nthawi kwa chothandizira chomwe chimaphatikiza magulu a ma tuple obwereza ndikusintha zobwereza ndi maulalo akope limodzi losungidwa.
  • Kuwongolera magwiridwe antchito a mafunso omwe amagwiritsidwa ntchito ntchito zophatikiza, magulu amagulu (GROUPING SETS) kapena kugawa (ogawanika) matebulo. Kukonzekera kumaphatikizapo kugwiritsa ntchito ma hashes m'malo mwa deta yeniyeni pamene mukuphatikiza, zomwe zimapewa kuyika deta yonse mu kukumbukira pamene mukukonza mafunso akuluakulu. Mukagawanitsa, kuchuluka kwa zochitika zomwe magawo angatayidwe kapena kuphatikizidwa akulitsidwa.
  • Adawonjezera mwayi wogwiritsa ntchito ziwerengero zapamwambaadapangidwa pogwiritsa ntchito lamulo la CREATE STATISTICS kuti athandizire kukonza bwino mafunso omwe ali ndi OR mikhalidwe kapena mndandanda wakusaka pogwiritsa ntchito IN kapena mawu ALIYENSE.
  • Kuyeretsa ma index pakugwira ntchito kwafulumizitsa VACUUM pofananiza kusonkhanitsa zinyalala m'ma index. Pogwiritsa ntchito parameter yatsopano ya "PARALLEL", woyang'anira akhoza kudziwa kuchuluka kwa ulusi womwe udzayendetse nthawi imodzi kwa VACUUM. Adawonjezera kuthekera koyambitsa VACUUM yokhayokha pambuyo poyika deta.
  • Thandizo lowonjezera pakusanja kowonjezera, komwe kumakupatsani mwayi wogwiritsa ntchito zomwe zidasanjidwa kale kuti mufulumizitse kusanja pamagawo otsatila a mafunso. Kuti muwongolere kukhathamiritsa kwatsopano mu query planner, pali makonda "amathandiza_incremental_sort", yomwe imayatsidwa mwachisawawa.
  • Anawonjezera luso kuchepetsa kukula kubwereza mipata, kukulolani kuti mudzitsimikizire nokha kusungidwa kwa magawo alemba-ulesi (WAL) mpaka atalandiridwa ndi ma seva onse osunga zobwezeretsera omwe akulandira zofananira. Mipata yobwerezabwereza imalepheretsanso seva yoyamba kuchotsa mizere yomwe ingayambitse mikangano, ngakhale seva yosunga zobwezeretserayo ilibe intaneti. Kugwiritsa ntchito parameter max_slot_wal_keep_size Tsopano mutha kuchepetsa kukula kwa mafayilo a WAL kuti mupewe kutha kwa disk space.
  • Mphamvu zowunikira ntchito za DBMS zakulitsidwa: lamulo la EXPLAIN limapereka chiwonetsero cha ziwerengero zowonjezera pakugwiritsa ntchito chipika cha WAL; V pg_basebackup anapereka mwayi younikira udindo wa zosunga zobwezeretsera mosalekeza; Lamulo la ANALYZE limapereka chidziwitso cha momwe ntchitoyi ikuyendera.
  • Lamulo latsopano lawonjezeredwa pg_kutsimikizirani kuti muwone kukhulupirika kwa zosunga zobwezeretsera zopangidwa ndi lamulo la pg_basebackup.
  • Mukamagwira ntchito ndi JSON pogwiritsa ntchito opareshoni alireza Amalola ntchito ya datetime() kuti igwiritsidwe ntchito kusintha mawonekedwe a nthawi (zingwe za ISO 8601 ndi mitundu yanthawi ya PostgreSQL). Mwachitsanzo, mutha kugwiritsa ntchito zomanga "jsonb_path_query('["2015-8-1", "2015-08-12"]', '$[*] ? (@.datetime() < "2015-08-2" ".datetime ())')" ndi "jsonb_path_query_array('["12:30", "18:40"]', '$[*].datetime("HH24:MI")')".
  • Anawonjezera anamanga-ntchito gen_random_uuid () kupanga UUID v4.
  • Dongosolo logawanitsa limapereka chithandizo chokwanira pakubwereza zomveka komanso zomwe zafotokozedwa ndi mawu akuti "POSAKHALA".
    zoyambitsa zomwe zimagwira ntchito pamzere wa mzere.

  • Syntax "LANDIRANI POYAMBA" tsopano imalola kugwiritsa ntchito mawu akuti "WITH TIES" kubweza mizere yowonjezera yomwe ili kumapeto kwa zotsatira zomwe zapezedwa mutagwiritsa ntchito "ORDER BY".
  • Anakhazikitsa lingaliro la zowonjezera zodalirika ("kukulitsa kodalirika"), yomwe imatha kukhazikitsidwa ndi ogwiritsa ntchito wamba omwe alibe ufulu woyang'anira DBMS. Mndandanda wa zowonjezera zotere umatchulidwa poyamba ndipo ukhoza kukulitsidwa ndi superuser. Zowonjezera zodalirika zimaphatikizapo pgcrypto, tablefunc, hstore ndi zina zotero.
  • Njira yolumikizira matebulo akunja a Foreign Data Wrapper (postgres_fdw) imagwiritsa ntchito kuthandizira kutsimikizika kozikidwa pa satifiketi. Mukamagwiritsa ntchito kutsimikizika kwa SCRAM, makasitomala amaloledwa kupempha "kumanga njira"(njira yomanga).

Source: opennet.ru

Kuwonjezera ndemanga