Bayan shekara guda na ci gaba, an buga sabon reshe mai tsayi na PostgreSQL 15 DBMS. Za a fitar da sabuntawa ga sabon reshe cikin shekaru biyar har zuwa Nuwamba 2027.
Manyan sabbin abubuwa:
- Ƙara goyon baya ga umarnin SQL "MERGE", wanda yayi kama da kalmar "SAKI ... AKAN RIKICIN". MERGE yana ba ku damar ƙirƙirar maganganun SQL na sharadi waɗanda ke haɗa SINGANTA, KYAUTA, da DELETE ayyuka zuwa magana ɗaya. Misali, ta amfani da MERGE, zaku iya haɗa tebur biyu ta shigar da bayanan da suka ɓace da sabunta waɗanda suke. HADA INTO customer_account ca AMFANIN_transactions recent_T ON t.customer_id = ca.customer_id LOKACIN DA AKE MATSAYI SAI UPDATE SET balance = balance + deal_value IDAN BA'A daidaita ba sai ka shigar da (t.customer_id, balance) VALUES (t.customer_id,t).
- Algorithms don rarraba bayanai a ƙwaƙwalwar ajiya da akan faifai an inganta su sosai. Dangane da nau'in bayanai, gwaje-gwaje na nuna haɓakar saurin rarrabawa daga 25% zuwa 400%.
- Ayyukan taga ta amfani da row_number(), rank(), dense_rank() da kirga() an hanzarta.
- An aiwatar da yuwuwar aiwatar da tambayoyi tare da kalmar "SELECT DISTINCT".
- Hanya don haɗa tebur na waje Wrapper Bayanan Waje (postgres_fdw) yana aiwatar da tallafi don ayyukan asynchronous ban da ikon da aka ƙara a baya don aiwatar da buƙatun asynchronously zuwa sabar waje.
- Ƙara ikon yin amfani da algorithms na LZ4 da Zstandard (zstd) don damfara rajistan ayyukan ma'amala na WAL, wanda, a ƙarƙashin wasu nauyin aiki, na iya haɓaka aiki lokaci guda da adana sararin faifai. Don rage lokacin dawowa bayan gazawar, an ƙara goyan baya don maido da shafuffukan da ke bayyana a cikin log ɗin WAL.
- Pg_basebackup mai amfani ya ƙara tallafi don matsawa-gefen uwar garke na fayilolin ajiyar ta amfani da gzip, LZ4 ko hanyoyin zstd. Yana yiwuwa a yi amfani da naku na'urorin don adanawa, yana ba ku damar yin ba tare da buƙatar aiwatar da umarnin harsashi ba.
- An ƙara jerin sabbin ayyuka don sarrafa kirtani ta amfani da maganganu na yau da kullun: regexp_count(), regexp_instr(), regexp_like() da regexp_substr().
- An ƙara ikon tara nau'ikan kewayon ("multirange") zuwa aikin kewayon_agg().
- Ƙara yanayin tsaro_invoker, wanda ke ba ku damar ƙirƙirar ra'ayoyi waɗanda ke gudana azaman mai amfani maimakon mahaliccin kallo.
- Don kwafi na ma'ana, an aiwatar da goyan bayan tace layuka da ƙayyadaddun lissafin ginshiƙai, ba da damar a gefen mai aikawa don zaɓar ɓangaren bayanai daga tebur don maimaitawa. Bugu da kari, sabon sigar yana sauƙaƙa sarrafa rikice-rikice, alal misali, yanzu yana yiwuwa a tsallake ma'amaloli masu karo da juna kuma a kashe biyan kuɗi ta atomatik lokacin da aka gano kuskure. Kwafi mai ma'ana yana ba da damar yin amfani da ƙaddamarwa lokaci biyu (2PC).
- An ƙara sabon tsarin log - jsonlog, wanda ke adana bayanai a cikin tsari mai tsari ta amfani da tsarin JSON.
- Mai gudanarwa yana da ikon ba da haƙƙin mutum ɗaya ga masu amfani don canza wasu sigogin saitin uwar garken PostgreSQL.
- Mai amfani da psql ya ƙara tallafi don neman bayanai game da saituna (pg_settings) ta amfani da umarnin "\ dconfig".
- An tabbatar da amfani da ƙwaƙwalwar ajiyar da aka raba don tara ƙididdiga game da aikin uwar garken, wanda ke ba da damar kawar da wani tsari na daban na tattara kididdiga da kuma sake saita jihar zuwa faifai lokaci-lokaci.
- An ba da ikon yin amfani da tsoffin wuraren ICU “Colation ICU”; a baya, wuraren libc kawai za a iya amfani da su azaman tsohuwar wurin.
- An ba da shawarar tsawaita ginanniyar pg_walinspect, wanda ke ba ku damar bincika abubuwan da ke cikin fayiloli tare da rajistan ayyukan WAL ta amfani da tambayoyin SQL.
- Don tsarin jama'a, duk masu amfani, ban da mai rumbun bayanai, sun sami ikon aiwatar da umarnin CREATE da soke.
- An cire tallafi don Python 2 a cikin PL/Python. An cire keɓantaccen yanayin wariyar ajiya.
Bugu da kari: Daga 19:00 zuwa 20:00 (MSK) za a yi wani webinar tattaunawa game da canje-canje a cikin sabon version tare da Pavel Luzanov (Postgres Professional). Ga wadanda ba su iya shiga watsa shirye-shirye, rikodin rahoton Pavel na Yuni "PostgreSQL 15: MERGE da ƙari" a PGConf.Russia yana buɗewa.
source: budenet.ru