Bayan shekara guda na ci gaba sabon reshe barga na PostgreSQL 12 DBMS. Sabuntawa don sabon reshe shekaru biyar har zuwa Nuwamba 2024.
Main :
- Ƙara goyon baya ga"", darajar wanda aka ƙididdige shi bisa la'akari da furcin da ke rufe ƙimar wasu ginshiƙai a cikin tebur guda (mai kama da ra'ayi, amma ga ginshiƙai ɗaya). ginshiƙan da aka samar na iya zama nau'i biyu - adanawa da kama-da-wane. A cikin shari'ar farko, ana ƙididdige ƙimar a lokacin da aka ƙara ko canza bayanai, kuma a cikin yanayi na biyu, ana ƙididdige ƙimar akan kowane karantawa bisa yanayin halin yanzu na wasu ginshiƙai. A halin yanzu, PostgreSQL kawai yana goyan bayan ginshiƙan da aka samar;
- An ƙara ikon neman bayanai daga takaddun JSON ta amfani da su , tunawa kuma an bayyana a cikin ma'aunin SQL/JSON. Ana amfani da hanyoyin ƙididdigewa da ake amfani da su don inganta ingantaccen sarrafa irin waɗannan maganganun don takaddun da aka adana a cikin tsarin JSONB;
- An kunna ta ta tsohuwa shine amfani da mai tarawa JIT (Just-in-Time) dangane da ci gaban LLVM don hanzarta aiwatar da wasu maganganu yayin sarrafa tambayar SQL. Misali, ana amfani da JIT don hanzarta aiwatar da maganganu a cikin INA tubalan, lissafin manufa, jimlar maganganu, da wasu ayyuka na ciki;
- An inganta aikin fihirisa sosai. An inganta firikwensin bishiyar B don yin aiki a cikin wuraren da fihirisar ke canzawa akai-akai - Gwajin TPC-C yana nuna haɓakar gabaɗayan aiki da matsakaicin raguwar amfani da sararin samaniya na 40%. Rage sama lokacin samar da log-ahead log (WAL) don nau'ikan fihirisar GiST, GIN da SP-GiST. Don GiST, an ƙara ikon ƙirƙirar firikwensin nannade (ta hanyar magana ta INCLUDE) waɗanda suka haɗa da ƙarin ginshiƙai. A cikin aiki Yana ba da goyan baya ga ƙididdiga mafi yawan gama gari (MCV) don samar da mafi kyawun tsare-tsaren tambaya yayin amfani da ginshiƙai marasa daidaituwa;
- An inganta aiwatar da rarrabuwar kawuna don tambayoyin da suka mamaye teburi tare da dubunnan ɓangarori, amma an iyakance su ga zaɓin ƙayyadaddun ɓangaren bayanai. Ayyukan ƙara bayanai zuwa teburin da aka raba ta amfani da ayyukan INSERT da COPY an haɓaka, kuma yana yiwuwa a ƙara sabbin sassa ta hanyar "ALTER TABLE ATTACH PARTITION" ba tare da toshe aiwatar da tambaya ba;
- Ƙarin tallafi don faɗaɗa layi ta atomatik na maganganun tebur gabaɗaya (, CTE) wanda ke ba da damar amfani da saitin sakamako mai suna na ɗan lokaci da aka ƙayyade ta amfani da bayanin WITH. Ƙaddamar da layi na iya inganta aikin mafi yawan tambayoyin, amma a halin yanzu ana amfani da shi kawai don CTEs marasa maimaitawa;
- Ƙara goyon baya Kaddarorin yanki na "Collation", wanda ke ba ku damar saita ƙa'idodin rarrabawa da hanyoyin daidaitawa da la'akari da ma'anar haruffa (alal misali, lokacin rarraba ƙimar dijital, kasancewar ragi da digo a gaban lamba da nau'ikan daban-daban. ana la'akari da rubutun kalmomi, kuma idan aka kwatanta, ba a la'akari da yanayin haruffa da kasancewar alamar lafazin);
- Ƙara goyon baya don ingantaccen abokin ciniki mai abubuwa da yawa, wanda a cikin pg_hba.conf zaka iya haɗa takaddun shaida ta SSL (clientcert=verify-full) tare da ƙarin hanyar tabbatarwa kamar scram-sha-256 don tabbatarwa;
- Ƙara goyon baya don ɓoyayyen tashar sadarwa lokacin tantancewa ta hanyar , duka a gefen abokin ciniki da kuma a gefen uwar garke;
- Ƙara goyon baya don ƙayyade sabar LDAP dangane da bayanan "DNS SRV" idan an gina PostgreSQL tare da OpenLDAP;
- Ƙara aiki"» don sake gina fihirisar ba tare da toshe ayyukan rubutawa zuwa index ba;
- Tawagar ta kara da cewa , wanda ke ba ka damar kunna ko kashe duba kididdigar shafukan bayanai don bayanan da ake da su (a baya wannan aikin ana tallafawa ne kawai yayin fara tattara bayanai);
- Samar da fitowar alamar ci gaba don ayyukan KIRKIRI INDEX, REINDEX, CLUSTER, FULL VACUUM da pg_checksums;
- Ƙara umarni"» don haɗa masu aiki don sabbin hanyoyin ajiyar tebur waɗanda aka inganta don takamaiman ayyuka daban-daban. A halin yanzu hanyar samun damar tebur kawai da aka gina a ciki ita ce "tulle";
- An haɗa fayil ɗin sanyi na recovery.conf tare da postgresql.conf. A matsayin alamun canji zuwa yanayin farfadowa bayan gazawar, yanzu yi amfani da recovery.signal da jiran aiki fayiloli.
source: budenet.ru