Bayan shekara guda na ci gaba, an buga sabon reshe mai tsayi na PostgreSQL 14 DBMS. Za a fitar da sabuntawa ga sabon reshe cikin shekaru biyar har zuwa Nuwamba 2026.
Manyan sabbin abubuwa:
- Ƙara goyon baya don samun damar bayanan JSON ta amfani da maganganu masu kama da tsari: SELECT ('{"postgres": {"saki": 14}'::jsonb) ['postgres']['saki']; Zaɓi * DAGA gwaji INA cikakkun bayanai['halaye'] ['size'] = "matsakaici"';
Ana aiwatar da irin wannan haɗin gwiwa don maɓalli/darajar bayanan da aka bayar ta nau'in hstore. An fara aiwatar da wannan haɗin gwiwar ta amfani da tsarin duniya, wanda a nan gaba za a iya amfani da shi don wasu nau'ikan. Misali na nau'in hstore: SHIGA CIKIN ABINDA AKE GUDA ('a=>b, c=>d'); Zaɓi h['a'] DAGA m; UPDATE mytable SET h['c'] = 'sabo';
- An faɗaɗa dangin nau'ikan ma'anar jeri tare da sabbin nau'ikan "multirange", waɗanda ke ba ku damar ƙididdige jeri na ƙimar ƙima ba tare da juna ba. Baya ga kowane nau'in kewayawa data kasance, ana ba da shawarar nau'in sa na dasawa, intimtafter ", da nau'in" distange ". Amfani da sabbin nau'ikan yana sauƙaƙa ƙirar tambayoyin da ke sarrafa hadaddun jeri na jeri. Zaɓi '{[4), [4)}'::int3,7multirange; ZABEN lamba (8,9, 4), lamba (1.0, 14.0));
- An inganta haɓakawa don inganta aikin manyan kayan aiki na tsarin aiki mai yawa na haɗin gwiwa. A wasu gwaje-gwaje, ana ganin haɓakar aiki sau biyu.
- An inganta ingantaccen ma'auni na B-itace kuma an warware matsalar haɓakar ƙididdiga lokacin da ake sabunta tebur akai-akai.
- Ƙarin tallafi don ɓangaren abokin ciniki (wanda aka aiwatar a matakin libpq) yanayin watsa buƙatun bututun, wanda ke ba ku damar haɓaka yanayin bayanan bayanai da ke da alaƙa da aiwatar da babban adadin ƙananan ayyukan rubutu (SAKA / UPDATE / GAME) ta hanyar aika bukata ta gaba ba tare da jiran sakamakon na baya ba. Hakanan yanayin yana taimakawa haɓaka aiki akan haɗin gwiwa tare da dogon jinkirin isar da fakiti.
- Ingantattun damar don daidaitawa da aka rarraba wanda ya ƙunshi sabar PostgreSQL da yawa. A cikin aiwatar da kwafin ma'ana, yanzu ya zama mai yiwuwa a aika ma'amaloli da ke ci gaba a cikin yanayin haɓakawa, wanda zai iya haɓaka aikin kwafin manyan ma'amaloli. Bugu da kari, an inganta ma'anar tantance bayanan da aka samu yayin kwafin hankali.
- Hanya don haɗa tebur na waje Wrapper Bayanan Waje (postgres_fdw) ya ƙara goyan baya don sarrafa tambaya guda ɗaya, wanda a halin yanzu kawai ake amfani da shi lokacin haɗawa zuwa wasu sabar PostgreSQL. postgres_fdw kuma yana ƙara goyan baya don ƙara bayanai zuwa tebur na waje a cikin yanayin batch da kuma ikon shigo da teburin da aka raba ta hanyar tantance umarnin "SIMPORT FOREIGN SCHEMA".
- An inganta haɓakawa don aiwatar da aikin VACUUM (tarin datti da marufi na ajiyar diski). An ƙara yanayin tsabtace gaggawa wanda ke tsallake ayyukan tsaftace marasa mahimmanci idan an ƙirƙiri yanayin kuɗaɗen ID na ma'amala. Rage sama lokacin sarrafa fihirisa a cikin tsarin B-Bishiyar. Ana aiwatar da aikin "ANALYZE", wanda ke tattara kididdiga game da yadda ake gudanar da bayanan, an ƙara haɓaka sosai.
- An ƙara ikon daidaita hanyar matsawa da ake amfani da shi a cikin tsarin TOAST, wanda ke da alhakin adana manyan bayanai, kamar tubalan rubutu ko bayanan geometric. Baya ga hanyar matsawa pglz, TOAST na iya amfani da algorithm na LZ4 yanzu.
- An faɗaɗa kayan aikin sa ido kan ayyukan DBMS. Ƙara ra'ayoyi don bin diddigin ci gaban umarnin COPY (pg_stat_progress_copy), ƙididdiga game da ramummuka na kwafi (pg_stat_replication_slots) da ayyuka masu alaƙa da log ɗin ciniki na WAL (pg_stat_wal). An ƙara aikin compute_query_id, wanda ke ba da dama ga tsarin ƙasa daban-daban, kamar pg_stat_activity da EXPLAIN VERBOSE, don biyan buƙatun ta hanyar sanya mai ganowa na musamman ga kowace buƙata.
- An ƙara haɓakawa ga mai tsara tambaya don haɓaka aiki na layi ɗaya na tambayoyin da haɓaka aikin aiwatar da ayyukan bincike na lokaci guda, aiwatar da tambayoyin a layi daya a cikin PL/pgSQL ta amfani da umarnin "RETURN QUERY", da kuma aiwatar da tambayoyi a layi daya a cikin " SANYA RA'AYIN ARZIKI”. Don inganta aikin haɗin kai (haɗuwa), an aiwatar da tallafi don ƙarin caching.
- Ana iya amfani da ƙwararrun ƙididdiga a yanzu don haɓaka maganganu, kuma ana iya amfani da rarrabuwa na ƙara yanzu don inganta ayyukan taga.
- Hanyoyi da aka adana waɗanda ke ba ku damar sarrafa ma'amaloli a cikin tubalan lamba yanzu suna goyan bayan ayyana bayanan dawowa ta amfani da sigogi na "OUT".
- Ƙara aikin date_bin zuwa ƙimar tambarin lokaci bisa ƙayyadaddun tazara. SELECT date_bin('minti 15', TIMESTAMP '2020-02-11 15:44:17', TIMESTAMP'2001-01-01'); 2020-02-11 15:30:00
- Ƙara SEARCH da maganganun CYCLE da aka ayyana a ma'aunin SQL don sauƙaƙe yin oda da gano hawan keke a cikin Maganganun Tebur gama gari (CTE). TARE DA RECURSIVE search_itace(id, mahada, data) AS ( SELECT t.id, t.link, t.data DAGA itace t UNION DUK SELECT t.id, t.link, t.data DAGA itace t, search_itace ST INA t. id = st.link ) BINCIKE ZURFIN FARKO TA Id SET ordercol ZABI * DAGA SEARKIN_TARE TA oda;
- A cikin psql utility, an inganta atomatik cika umarni tare da shafuka, an ƙara ikon nuna hujjar aiki zuwa umarnin "\ df", kuma an faɗaɗa kididdigar da aka nuna zuwa umarnin "\ dX".
- Yana yiwuwa a ba wa masu amfani damar karanta-kawai ko rubuta-kawai. Ana iya saita gata akan teburi guda ɗaya, ra'ayoyi, da tsare-tsare ta amfani da pg_read_all_data da pg_write_all_data ayyana matsayin. KYAUTA pg_read_duk_data ZUWA mai amfani1;
- Sabbin shigarwar da aka riga aka shigar zuwa kalmar sirri ta amfani da SCRAM-SHA-256 maimakon md5 (madaidaicin "password_encryption" lokacin samar da postgresql.conf yanzu an saita zuwa 'scram-sha-256').
source: budenet.ru