PostgreSQL tsarin gudanar da bayanai ne na buɗaɗɗen tushen abu.
Bayan shekara guda na cigaba An sanar da sakin sabon reshe na DBMS PostgreSQL 15, Wannan sakin ya haɗa da abubuwan haɓakawa da yawa, gami da sabbin damar matsawa waɗanda ke taimakawa tare da ajiyar bayanai da madadin, haɓakawa ga rarraba bayanai don saurin dubawa, da sabon SQL da damar shiga.
A cikin wannan sabon sigar da aka gabatar, umarnin SQL "MERGE" yana haskakawa, que yana ba ku damar ƙirƙirar maganganun SQL na sharadi wanda ke haɗa INSERT, UPDATE, da DELETE ayyuka a cikin sanarwa ɗaya. Misali, ana iya amfani da MERGE don haɗa tebur biyu ta hanyar saka bayanan da suka ɓace da sabunta waɗanda suke.
Umurnin yana ba da damar haɗa tebur kuma yana sa PostgreSQL ya fi dacewa tare da tsarin kula da bayanai na tushen tushen SQL Server, gami da Microsoft SQL Server da SAP ASE uwar garken bayanai na dangantaka, da duk wasu waɗanda ke goyan bayan ƙungiyar Transact-SQL na kari na shirye-shirye.
Wani canji da ya yi fice a cikin wannan sabon sigar shine a cikin algorithms don rarraba bayanai a cikin ƙwaƙwalwar ajiya da akan faifai an inganta su sosai. Dangane da nau'in bayanai a cikin gwaje-gwajen, ana samun karuwar saurin rarrabawa daga 25% zuwa 400%.
Don kwafin hankali, Ana aiwatar da tallafi don tace layuka da ƙayyadaddun lissafin ginshiƙai, wanda ke ba da damar, a gefen mai aikawa, don zaɓar ɓangaren bayanai don kwafin tebur. Bugu da kari, sabon sigar ya sauƙaƙa sarrafa rikici, misali ikon tsallake ma'amaloli masu karo da juna da kuma cire haɗin kuɗin shiga ta atomatik lokacin da aka gano kuskure. Kwafi mai ma'ana yana ba da damar yin amfani da ayyuka biyu-biyu (2PCs).
Hanya don haɗa tebur na waje Akwatin bayanai na waje (postgres_fdw) yana aiwatar da tallafi don ayyukan asynchronous baya ga ƙara ikon aiwatar da buƙatun zuwa sabar na waje asynchronously.
Ƙara ikon yin amfani da LZ4 da Zstandard algorithms (zstd) don damfara rajistan ayyukan ciniki na WAL, wanda, ƙarƙashin wasu nauyin aiki, na iya haɓaka aiki lokaci guda tare da adana sarari diski, da ƙara goyan baya don maido da shafuffukan da suka bayyana a cikin log ɗin ciniki.WAL don rage lokacin dawo da gazawa.
An kuma haskaka cewa ƙara zuwa pg_basebackup mai amfani la goyon baya don matsawa madadin fayiloli a gefen uwar garken amfani gzip, LZ4, ko hanyoyin zstd. An ba da ikon yin amfani da na'urorin ku don adanawa, wanda ke ba ku damar rarraba tare da buƙatar aiwatar da umarnin harsashi.
Baya ga waccan, yanzu a cikin PostgreSQL 15 An tabbatar da amfani da ƙwaƙwalwar ajiyar da aka raba don tarin ƙididdiga akan aikin uwar garken, wanda ya sa ya yiwu a kawar da wani tsari na daban na tattara kididdiga da kuma zubar da jihar zuwa faifai lokaci-lokaci.
Daga sauran canje-canjen da suka fice daga sabon sigar:
- Ƙara sabbin ayyuka don aiwatar da kirtani ta amfani da maganganun yau da kullun: regexp_count(), regexp_instr(), regexp_like(), da regexp_substr().
- An ƙara ikon ƙara nau'ikan kewayon yawa ("yawan-jeri") zuwa aikin kewayon_agg().
An ƙara yanayin tsaro_invoker don ba da damar ƙirƙirar ra'ayoyi waɗanda ke gudana tare da haƙƙin mai amfani, maimakon mahaliccin kallo. - An ƙara sabon tsarin log: jsonlog, wanda ke adana bayanai ta hanyar da aka tsara 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.
- An ƙara tallafi don mai amfani na psql don bincika bayanai game da saituna (pg_settings) ta amfani da umarnin "\ dconfig".
- An gabatar da tsawaita ginanniyar pg_walinspect wanda zai ba ku damar bincika abubuwan da ke cikin fayiloli tare da bayanan WAL ta amfani da tambayoyin SQL.
- An cire tallafin Python 2 a cikin PL/Python
- An cire yanayin "keɓaɓɓen madadin".
- Ana aiwatar da yuwuwar aiwatar da tambayoyi tare da kalmar "SELECT DISTINCT".
A karshe yana da kyau a ambaci hakan Za a fitar da sabuntawa don sabon reshe na tsawon shekaru biyar har zuwa Nuwamba 2027. Idan kuna sha'awar ƙarin sani game da shi, kuna iya tuntuɓar cikakkun bayanai a cikin bin hanyar haɗi.